ComboBox problem
 

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?

ComboBox problem
 

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:

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?

ComboBox problem
 

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.

"Stefi" wrote:

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:

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?

ComboBox problem
 

p45cal;581451 Wrote:
What's your current code?

Really, it would be useful..


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160804

Microsoft Office Help

ComboBox problem
 

p45cal is right: then post your code!

--
Regards!
Stefi



€žhoyos€� ezt Ã*rta:

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.

"Stefi" wrote:

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:

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?