ComboBox problem

H

hoyos

On my Userform, there is one ComboBox with 5 TextBoxes. Depending what is
selected on the dropdown list of the ComboBox will depend what is displayed
in the TextBoxes. The problem I have is that when choosing an item from the
list in order to update the data in the TextBoxes I have to select one
TextBox.
Is there a way so that the moment an item is selected it changes all the
textboxes?
 
P

p45cal

hoyos;581328 said:
On my Userform, there is one ComboBox with 5 TextBoxes. Depending what
is
selected on the dropdown list of the ComboBox will depend what is
displayed
in the TextBoxes. The problem I have is that when choosing an item from
the
list in order to update the data in the TextBoxes I have to select one
TextBox.
Is there a way so that the moment an item is selected it changes all
the
textboxes?

What's your current code?
 
S

Stefi

Maybe you should create a similar event sub:

Private Sub ComboBox1_Change()
UserForm1.TextBox1.Value = ComboBox1.Value
UserForm1.TextBox2.Value = ComboBox1.Value
End Sub

--
Regards!
Stefi



„hoyos†ezt írta:
 
H

hoyos

Sorry Stef, it doesn't work. I still need to select a textbox, after
selecting a item from the combobox, for the figures to update.
 
S

Stefi

p45cal is right: then post your code!

--
Regards!
Stefi



„hoyos†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top