Combobox and Textbox settings

[Chris Gorham]

hi,

what are the settings on a combobox to prevent the user editing entries
(the list of user names) that I've loaded using the "additem" method...if he
does edit his user name then it confuses the VLookup statement that the
combobox feed
when it changes. I've tried every setting under combobox and nothing seems to
prevent this.

I also require that the user type in his password into a text box when he
selects his user name from the combobox drop down. The text box for the
password has "Enter Password" loaded in to it when the combobox
changes...however it would be nice to have this text highlighted such that
when he types, he types immediately over it rather than having to delete
these words first.

again tried every setting for text boxes and used "set focus" to the text
box when the combo box changes...no luck...

thanks for your help...Chris

 

[Chip Pearson]

Chris,

Change the Style property to 2, fmStyleDropDownList. You can do this at
design time or at run-time with code like

UserForm1.ComboBox1.Style = fmStyleDropDownList

This will prevent the user from change the value of the combobox to a value
that is not in the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Mike Fogleman]

On your problem 2 of getting the textbox text to be highlighted use SendKeys
to change the focus from the combobox to the textbox.

Private Sub ComboBox1_Change()
Me.TextBox1.Text = "Enter Password"
SendKeys "{TAB}"
End Sub

Mike F