Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combobox problem in protected sheet | Excel Discussion (Misc queries) | |||
Problem Using Delete Key Because of Combobox | Excel Discussion (Misc queries) | |||
Strange problem with a combobox and ListFillRange | Excel Discussion (Misc queries) | |||
Excel combobox problem | Excel Discussion (Misc queries) |