| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Form ComboBox question
Help !!!
I know this is most likely a simple question, but I'm stuck :( I not to populate a Combo box in an Excel spread sheet I just enter the location in the ListFillRange (EmpData!A1:A100). But I got creative and tryed making a Userform with VBA. Now I'm lost :( In VBA the combo box doesn't have a ListFillRange.... One place I read to enter the location in the ControlSource field, but it doesn't take the information. It keeps giving me an error message. Can anyone Help Please? Thanks Wally |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Form ComboBox question
replies elsewhere, don't multipost.
-- HTH RP (remove nothere from the email address if mailing direct) "WTG" wrote in message ... Help !!! I know this is most likely a simple question, but I'm stuck :( I not to populate a Combo box in an Excel spread sheet I just enter the location in the ListFillRange (EmpData!A1:A100). But I got creative and tryed making a Userform with VBA. Now I'm lost :( In VBA the combo box doesn't have a ListFillRange.... One place I read to enter the location in the ControlSource field, but it doesn't take the information. It keeps giving me an error message. Can anyone Help Please? Thanks Wally |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Form ComboBox question
You have a response in both .worksheet.functions and .misc.
WTG wrote: Help !!! I know this is most likely a simple question, but I'm stuck :( I not to populate a Combo box in an Excel spread sheet I just enter the location in the ListFillRange (EmpData!A1:A100). But I got creative and tryed making a Userform with VBA. Now I'm lost :( In VBA the combo box doesn't have a ListFillRange.... One place I read to enter the location in the ControlSource field, but it doesn't take the information. It keeps giving me an error message. Can anyone Help Please? Thanks Wally -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Form ComboBox question
Thank you
On Sat, 26 Feb 2005 07:25:57 -0600, Dave Peterson wrote: You have a response in both .worksheet.functions and .misc. WTG wrote: Help !!! I know this is most likely a simple question, but I'm stuck :( I not to populate a Combo box in an Excel spread sheet I just enter the location in the ListFillRange (EmpData!A1:A100). But I got creative and tryed making a Userform with VBA. Now I'm lost :( In VBA the combo box doesn't have a ListFillRange.... One place I read to enter the location in the ControlSource field, but it doesn't take the information. It keeps giving me an error message. Can anyone Help Please? Thanks Wally |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| form control combobox | Excel Discussion (Misc queries) | |||
| Form Help - ComboBox - VBA | Excel Discussion (Misc queries) | |||
| link form combobox | Excel Worksheet Functions | |||
| VBA Form ComboBox question | Excel Worksheet Functions | |||
| Excel 2000 VBA Form Combobox value | Excel Programming | |||
Linear Mode
