S shutzy Registered User. Local time Today, 00:16 Joined Sep 14, 2011 Messages 775 Dec 18, 2013 #1 I have vba that runs at 08:30 am. I would now like to run vba on the 1st of each month. how do I do this. for the time I use If TimeValue(Me.txtClock) = TimeValue("08:30 AM") Then.......... thank you
I have vba that runs at 08:30 am. I would now like to run vba on the 1st of each month. how do I do this. for the time I use If TimeValue(Me.txtClock) = TimeValue("08:30 AM") Then.......... thank you
pr2-eugin Super Moderator Local time Today, 00:16 Joined Nov 30, 2011 Messages 8,494 Dec 18, 2013 #2 Something like.. Code: If Date() = DateSerial(Year(Date()), Month(Date()), 1) Then
S shutzy Registered User. Local time Today, 00:16 Joined Sep 14, 2011 Messages 775 Dec 18, 2013 #3 thank you. perfect as usual
pr2-eugin Super Moderator Local time Today, 00:16 Joined Nov 30, 2011 Messages 8,494 Dec 18, 2013 #4 Ha Ha ! No problemo !
