Activate Combo Box

robfo0 · Mar 10th, 2002, 09:20 PM

Me again!

I just want you all to know before i post all these questions, I am searching the excel help and the archives on this board

When the button on my userform is pressed, my macro tests to see if the text boxes and combo boxes have values. if they dont, it gives a message. I am this far, but i would also like the code to activate the section of the userform that is missing data. I thought something like:

Msgbox("Please enter a name:")
Me.Name.Activate

(where Name is the name of a text box in the userform)

but .activate isnt the correct way.

Thanks in advanced for the help

robfo0 · Mar 10th, 2002, 09:27 PM

OH! found it in one of my books

me.Name.SetFocus

yay!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 10th, 2002, 09:20 PM	#1
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Me again! I just want you all to know before i post all these questions, I am searching the excel help and the archives on this board When the button on my userform is pressed, my macro tests to see if the text boxes and combo boxes have values. if they dont, it gives a message. I am this far, but i would also like the code to activate the section of the userform that is missing data. I thought something like: Msgbox("Please enter a name:") Me.Name.Activate (where Name is the name of a text box in the userform) but .activate isnt the correct way. Thanks in advanced for the help

Mar 10th, 2002, 09:27 PM	#2
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	OH! found it in one of my books me.Name.SetFocus yay!