Determine if Commandbutton is clicked

**puuts** · 05-06-2014, 12:19 PM

Hi,

Can anyone help me with my problem.
I have a userform with commandbutton. I just want when the userform initialize and if the pc time is 9:00 PM and the commandbutton is
unclicked, msgbox will display "Unclicked" else do nothing.

Something like this, but i can't get the right syntax:

Please Login or Register  to view this content.

**Kaper** · 05-06-2014, 01:03 PM

The command button do not store it's status (it is clicked only during clicking action). Moreover you say about UF initialize.
So you shall store somewhere (static variable, external file, hidden cell, etc.) info that the button has been clicked and then use this stored info in initialization.
Think when to mark this variable as "unclicked" - may be just after your if-end if command. and of course include in your CommandButton1_Click proc setting this variable as clicked.

**puuts** · 05-06-2014, 01:11 PM

I see. Thanks Kalper.

I've ended with this.

Please Login or Register  to view this content.

So what's the syntax for the time?

Please Login or Register  to view this content.

**Kaper** · 05-06-2014, 03:10 PM

So:

Please Login or Register  to view this content.

But note that (not tested) in my opinion txtbox1 value will be always "" while you do Initialize. I think that info about clicking shall be stored outside code of Userform.