Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Timed combobox

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi I have created combo box so that when a sheet opens up you can insert a date into cell, I was wondering if anybody knew how I could have it automatically pop up once a week when the sheet is opened up.
    please can somebody help me.
    Thank you

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try putting in an if statement like the following:
    Private Sub Worksheet_Activate()
    If WeekdayName(Weekday(Date)) = "Tuesday" Then UserForm1.Show
    End Sub

    The code will show userform1 every Tuesday, when the worksheet is activated. You can put the code in the module for the worksheet.

    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •