Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot enter control for drop down box
Please help. I am trying to use a drop down box linked to a cell. I have
done this a hundred times before and in the past when I create the drop down box I can right click on it and select "Format Control". I can then select the Format Tab. This allows me to select the range of data for the list and the linked cell. For some reason in a current project I create the box and right click, select Format Control and the Format Control tab is not available. I also have following in the formula bar the following =EMBED("Forms.ConboBox.1",""). Normally I would not have this. Thank you in advance for any assistance with this. Ken |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot enter control for drop down box
You used a combobox from the control toolbox toolbar.
Delete it and replace it with a dropdown from the Forms toolbar and you'll see what you expect. Ken wrote: Please help. I am trying to use a drop down box linked to a cell. I have done this a hundred times before and in the past when I create the drop down box I can right click on it and select "Format Control". I can then select the Format Tab. This allows me to select the range of data for the list and the linked cell. For some reason in a current project I create the box and right click, select Format Control and the Format Control tab is not available. I also have following in the formula bar the following =EMBED("Forms.ConboBox.1",""). Normally I would not have this. Thank you in advance for any assistance with this. Ken -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot enter control for drop down box
OK, I feel really stupid. This was driving me crazy as I couldn't figure out
why. Thank you very much, I really appreciate it! Ken "Dave Peterson" wrote: You used a combobox from the control toolbox toolbar. Delete it and replace it with a dropdown from the Forms toolbar and you'll see what you expect. Ken wrote: Please help. I am trying to use a drop down box linked to a cell. I have done this a hundred times before and in the past when I create the drop down box I can right click on it and select "Format Control". I can then select the Format Tab. This allows me to select the range of data for the list and the linked cell. For some reason in a current project I create the box and right click, select Format Control and the Format Control tab is not available. I also have following in the formula bar the following =EMBED("Forms.ConboBox.1",""). Normally I would not have this. Thank you in advance for any assistance with this. Ken -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
control enter | Excel Discussion (Misc queries) | |||
Calendar control on cell enter? | Excel Worksheet Functions | |||
Drop Down Form control always causes excel to crash | Excel Discussion (Misc queries) | |||
Control Display of Drop Down List in Validation | Excel Worksheet Functions | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) |