Show userform on certain dates

[Paddy1979]

Hello All,

Please can you help.

I want to set my worksheet so that when it is opened and the date in this example is between 20/10/06 & 25/10/06 it will show my userform,
i guess this is done via workbook open i'm just unsure of the code.

Hope that makes sense

Regards
Paddy

 

[erik.van.geit]

Hi,

try this

Private Sub Workbook_Open()
If Date > DateSerial(2006, 10, 20) And Date < DateSerial(2006, 10, 25) Then userform1.Show
'If Date > "20/10/06" And Date < "25/10/06" Then userform1.Show
End Sub

I'm not sure the second line would work on all systems

kind regards,
Erik

 

[Paddy1979]

thanks eric