| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define Range for Combo Box
Is it possible to define a cell range for a combo box list on a user form.
If yes then how would you write the code ? I know I could list with .AddItem "" but I have a possible list of 200 entries so I'm looking for a shortcut. regards GregK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Define Range for Combo Box
Firstly, name your array
ComboBox1.List = Range("a").Value e.g. assumes "a" is the named array |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Define Range for Combo Box
Greg,
Set the RowSource property to the range. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gregork" wrote in message ... Is it possible to define a cell range for a combo box list on a user form. If yes then how would you write the code ? I know I could list with ..AddItem "" but I have a possible list of 200 entries so I'm looking for a shortcut. regards GregK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define Name range | Excel Discussion (Misc queries) | |||
| Name to define a chart range | Excel Discussion (Misc queries) | |||
| Define a range | Excel Discussion (Misc queries) | |||
| Apply Name (Define Name, Name Range) | Excel Discussion (Misc queries) | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Hybrid Mode
