• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto Fill Userform TextBox when a value is selected in ComboBox

Chihiro

Excel Ninja
1. Set up your Combobox1 as follows.
78745

This will set up combobox with 2 columns. But only display 1st column value.
I don't know how you are loading data to your combobox. But load both columns as one.

2. Then using Combobox1_Change() event. Retrieve and set Textbox3 value.
Note: Column(1) = second column. As it uses 0 base index.
Ex:
Code:
Private Sub ComboBox1_Change()
TextBox3.Value = ComboBox1.Column(1)
End Sub
 
Top