View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default 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....