Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo Box Imbedded in Cell?
I've inherited an Excel application that has combo boxes imbedded in
worksheet cells. They are NOT validation lists or worksheet controls. No VBA or macros exist in the application. There are no range names in the application. I can not find the lists from the combo boxes anywhere in the workbook. Clicking on a list item appears to change the scroll area. I can not left or right click into properties while in design mode. What are these strange objects? How do I "look inside them?" I am looking at a book that tells me to click on "OptionButton Object|Edit" from the pop-up menu. I can find no such option. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo Box Imbedded in Cell?
The "combo box" is an auto filter. Select cells to filter. click
Data/Filter/AutoFilter. "Pictou" wrote: I've inherited an Excel application that has combo boxes imbedded in worksheet cells. They are NOT validation lists or worksheet controls. No VBA or macros exist in the application. There are no range names in the application. I can not find the lists from the combo boxes anywhere in the workbook. Clicking on a list item appears to change the scroll area. I can not left or right click into properties while in design mode. What are these strange objects? How do I "look inside them?" I am looking at a book that tells me to click on "OptionButton Object|Edit" from the pop-up menu. I can find no such option. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Imbedded Objects with filters on | Excel Worksheet Functions | |||
Links (multiple) to Imbedded W/S in adjacent cell | Excel Discussion (Misc queries) | |||
How do I insert OR in imbedded formulas? | Excel Worksheet Functions | |||
imbedded if statements | Excel Worksheet Functions | |||
Stripping out imbedded spaces in a cell/row | Excel Worksheet Functions |