What's the code for 'if commandbutton1 is clicked?

[Oliver Dewar]

Hi All,

I has an exit event in a textbox on a userform that sets focus on a combobox.

I have a 'Exit' button on the userform as well.

I simply need to say in the textbox exit event to setfocus on the combobox, unless the exit button is pressed.

Something like

private sub textbox1.exit (ByVal Cancel As MSForms.ReturnBoolean)
 
if not commandbutton1.click = True then
combobox1.setfocus
end if
 
end sub

But I don't know what the correct way to say commandbutton1.click = true is.

Thoughts ladies and gentlemen?

 

[mikerickson]

...What did you mean that the combobox would be invisible?

If you click on the corner X, the userform (and all its controls) will be invisible when the TextBox's Exit event runs.

 

[Oliver Dewar]

Mike... you are once again... the man!