Timed combobox

willlobb · Apr 9th, 2002, 07:54 AM

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

Al Chara · Apr 9th, 2002, 08:02 AM

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.

Apr 9th, 2002, 08:02 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 07:54 AM	#1
willlobb Board Regular Join Date: Mar 2002 Posts: 103	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