| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill a combo box from a named area on a sheet
I have a list of Hotels on a sheet with columns: location,
name and rate (the list is named HotelData). On another sheet I want to be able to select from that list, possibly via a combo or list box, with the data transferred to the relevant cells. Then by inputting the no of nights in another column I can thus build up a holiday itinerary with cost details. Trouble is I cant get the HotelData name accepted by the combo box control source on the properties sheet. Help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill a combo box from a named area on a sheet
Enter HotelData into the RowSource property, not ControlSource.
"Phil Walker" wrote in message ... I have a list of Hotels on a sheet with columns: location, name and rate (the list is named HotelData). On another sheet I want to be able to select from that list, possibly via a combo or list box, with the data transferred to the relevant cells. Then by inputting the no of nights in another column I can thus build up a holiday itinerary with cost details. Trouble is I cant get the HotelData name accepted by the combo box control source on the properties sheet. Help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation Combo box using Named Ranges | Excel Discussion (Misc queries) | |||
| Fill the values in combo box of excel sheet | Excel Worksheet Functions | |||
| Stacked area and area chart combo | Charts and Charting in Excel | |||
| Why I get gray area in sheet tab of page setup? can't resize area. | Excel Discussion (Misc queries) | |||
| combo box named range | Excel Discussion (Misc queries) | |||
Linear Mode
