Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Userform
Hi,
I have already populated a combox reffering cells from an excel sheet. Here is the Code. With ActiveSheet MyList(0, 0) = .Range("A1") MyList(1, 0) = .Range("A2") MyList(2, 0) = .Range("A3") MyList(3, 0) = .Range("A4") End With ComboBox2.List() = MyList Now i want to update or change values in excel sheet by typing the values in combo box. I tried to play with listindex, controlsource but could not make it. Anybody has an idea, please let me know. Thanks, Mazu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Userform
If the combobox doesn't have anything selected, and you type: QWER
What cell gets that value? If the combobox does have a value, how would you know what cell got the value? mazu wrote: Hi, I have already populated a combox reffering cells from an excel sheet. Here is the Code. With ActiveSheet MyList(0, 0) = .Range("A1") MyList(1, 0) = .Range("A2") MyList(2, 0) = .Range("A3") MyList(3, 0) = .Range("A4") End With ComboBox2.List() = MyList Now i want to update or change values in excel sheet by typing the values in combo box. I tried to play with listindex, controlsource but could not make it. Anybody has an idea, please let me know. Thanks, Mazu -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Userform
Hi Dave,
Thanks for your response. I am asking the same questions that you are asking. If you know how to solve this problem that will be great. "Dave Peterson" wrote: If the combobox doesn't have anything selected, and you type: QWER What cell gets that value? If the combobox does have a value, how would you know what cell got the value? mazu wrote: Hi, I have already populated a combox reffering cells from an excel sheet. Here is the Code. With ActiveSheet MyList(0, 0) = .Range("A1") MyList(1, 0) = .Range("A2") MyList(2, 0) = .Range("A3") MyList(3, 0) = .Range("A4") End With ComboBox2.List() = MyList Now i want to update or change values in excel sheet by typing the values in combo box. I tried to play with listindex, controlsource but could not make it. Anybody has an idea, please let me know. Thanks, Mazu -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Userform
Always put it in the top cell????
It's a solution, but probably not the correct one! mazu wrote: Hi Dave, Thanks for your response. I am asking the same questions that you are asking. If you know how to solve this problem that will be great. "Dave Peterson" wrote: If the combobox doesn't have anything selected, and you type: QWER What cell gets that value? If the combobox does have a value, how would you know what cell got the value? mazu wrote: Hi, I have already populated a combox reffering cells from an excel sheet. Here is the Code. With ActiveSheet MyList(0, 0) = .Range("A1") MyList(1, 0) = .Range("A2") MyList(2, 0) = .Range("A3") MyList(3, 0) = .Range("A4") End With ComboBox2.List() = MyList Now i want to update or change values in excel sheet by typing the values in combo box. I tried to play with listindex, controlsource but could not make it. Anybody has an idea, please let me know. Thanks, Mazu -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Userform
Ps. Maybe using Data|Form (xl2003 menus) would be more effective here.
mazu wrote: Hi Dave, Thanks for your response. I am asking the same questions that you are asking. If you know how to solve this problem that will be great. "Dave Peterson" wrote: If the combobox doesn't have anything selected, and you type: QWER What cell gets that value? If the combobox does have a value, how would you know what cell got the value? mazu wrote: Hi, I have already populated a combox reffering cells from an excel sheet. Here is the Code. With ActiveSheet MyList(0, 0) = .Range("A1") MyList(1, 0) = .Range("A2") MyList(2, 0) = .Range("A3") MyList(3, 0) = .Range("A4") End With ComboBox2.List() = MyList Now i want to update or change values in excel sheet by typing the values in combo box. I tried to play with listindex, controlsource but could not make it. Anybody has an idea, please let me know. Thanks, Mazu -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Userform
Hi Dave,
What do you mean by that "Data|Form (xl2003 menus" Thanks, "Dave Peterson" wrote: Ps. Maybe using Data|Form (xl2003 menus) would be more effective here. mazu wrote: Hi Dave, Thanks for your response. I am asking the same questions that you are asking. If you know how to solve this problem that will be great. "Dave Peterson" wrote: If the combobox doesn't have anything selected, and you type: QWER What cell gets that value? If the combobox does have a value, how would you know what cell got the value? mazu wrote: Hi, I have already populated a combox reffering cells from an excel sheet. Here is the Code. With ActiveSheet MyList(0, 0) = .Range("A1") MyList(1, 0) = .Range("A2") MyList(2, 0) = .Range("A3") MyList(3, 0) = .Range("A4") End With ComboBox2.List() = MyList Now i want to update or change values in excel sheet by typing the values in combo box. I tried to play with listindex, controlsource but could not make it. Anybody has an idea, please let me know. Thanks, Mazu -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Userform
I use xl2003. In xl2007, MS introduced the Ribbon. Everything got rearranged.
In xl2003, you'd click on the Data menu, then click on Form. I don't know where it is in xl2007. But I bet you could find it. mazu wrote: Hi Dave, What do you mean by that "Data|Form (xl2003 menus" Thanks, "Dave Peterson" wrote: Ps. Maybe using Data|Form (xl2003 menus) would be more effective here. mazu wrote: Hi Dave, Thanks for your response. I am asking the same questions that you are asking. If you know how to solve this problem that will be great. "Dave Peterson" wrote: If the combobox doesn't have anything selected, and you type: QWER What cell gets that value? If the combobox does have a value, how would you know what cell got the value? mazu wrote: Hi, I have already populated a combox reffering cells from an excel sheet. Here is the Code. With ActiveSheet MyList(0, 0) = .Range("A1") MyList(1, 0) = .Range("A2") MyList(2, 0) = .Range("A3") MyList(3, 0) = .Range("A4") End With ComboBox2.List() = MyList Now i want to update or change values in excel sheet by typing the values in combo box. I tried to play with listindex, controlsource but could not make it. Anybody has an idea, please let me know. Thanks, Mazu -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform combo box | Excel Programming | |||
~~ Help with Userform and Combo Box ~~ | Excel Programming | |||
Properties of Combo Box in Userform | Excel Programming | |||
UserForm and combo box to another sheet | Excel Discussion (Misc queries) | |||
Combo Box in userform | Excel Programming |