Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Individual values from a Combobox List placed in textboxes
How can I place 1 Value from a Combobox List into a separate Textboxes.
EG. If the Combobox list has 20 values, then each value placed into 20 different textboxes. How can i do that ? Corey.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Individual values from a Combobox List placed in textboxes
how are the combobox values added? did you add them one at a time?
or is it a range on a worksheet? if it's a range, you can add them to each textbox, as in......... me.txtfirst.value = sheets("nameofsheet").range("a5") me.txtsecond.value=sheets("nameofsheet").range("a6 ") for example. if you added them individually via code using the .additem method, i would think you could also declare them as a variable & then load the variable.value into the textboxes. susan On Jan 29, 10:04 pm, "Corey" wrote: How can I place 1 Value from a Combobox List into a separate Textboxes. EG. If the Combobox list has 20 values, then each value placed into 20 different textboxes. How can i do that ? Corey.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Individual values from a Combobox List placed in textboxes
assuming there are enough textboxes and they are named sequentially such as
Textbox1, Textbox2, etc. for i = 0 to listbox1.listcount - 1 me.controls("Textbox" & i + 1).Value = Listbox1.List(i) Next -- Regards, Tom Ogilvy "Corey" wrote: How can I place 1 Value from a Combobox List into a separate Textboxes. EG. If the Combobox list has 20 values, then each value placed into 20 different textboxes. How can i do that ? Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Unique Values in as a combobox value list | Excel Discussion (Misc queries) | |||
Filling Textboxes from Combobox selection | Excel Programming | |||
Combobox list to leave ONLY related values in list ?? | Excel Programming | |||
Combobox List to list Numerical Values ONLY in Column A is specific Sheet.... | Excel Programming | |||
how to populate a combobox with a list of unique values? | Excel Programming |