Oliver Dewar
Board Regular
- Joined
- Apr 17, 2011
- Messages
- 201
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
But I don't know what the correct way to say commandbutton1.click = true is.
Thoughts ladies and gentlemen?
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
Code:
private sub textbox1.exit (ByVal Cancel As MSForms.ReturnBoolean)
if not commandbutton1.click = True then
combobox1.setfocus
end if
end subBut I don't know what the correct way to say commandbutton1.click = true is.
Thoughts ladies and gentlemen?
