Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form Drop Down
I added a drop down control to my sheet1 from the forms menu.
I want the data which will show up in this control to be from a range name of "Products" from the "Data" sheet. If I place "Data!Products" into the "Input Range" on the Control Tab of the Format Control dialog box, the system changes this to my file name!Products. Do I not have the proper format for specifying the range? Can I reference this control in my VBA Code...I see no name that I can use for the object name.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form Drop Down
You do not need to specify the sheet when dealing with named ranges, if
"products" is the name of the range then type: =products HTH JG "Jim Heavey" wrote: I added a drop down control to my sheet1 from the forms menu. I want the data which will show up in this control to be from a range name of "Products" from the "Data" sheet. If I place "Data!Products" into the "Input Range" on the Control Tab of the Format Control dialog box, the system changes this to my file name!Products. Do I not have the proper format for specifying the range? Can I reference this control in my VBA Code...I see no name that I can use for the object name.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create drop down form fields in Excel? | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
How do I select form a drop down box by typing the first part? | Excel Worksheet Functions | |||
Drop downs in Data Form | Excel Discussion (Misc queries) | |||
How do I create a form with drop downs that narrows choices? | Excel Discussion (Misc queries) |