I have an Excel 2003 worksheet with a combobox created with the control toolbox (within Excel 2003) and would like to edit it with Excel 2007.
My challenge is that I cannot determine how to do it in Excel 2007. I have been going back to 2003 and making my changes there.
Any words of wisdom would be appreciated.
Thanks,
John
ComboBox in Excel 2007
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
ComboBox in Excel 2007
Regards,
John
John
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ComboBox in Excel 2007
In Excel 2007:
- Activate the Developer tab of the ribbon (*)
- Click the Design Mode button to turn it "on".
- You can now select the combo box and edit it.
- Don't forget to turn off Design Mode when you're done.
(*) If you don't see the Developer tab:
- Click the Office button.
- Click Excel Options.
- Tick the check box "Show Developer tab in the Ribbon".
- Click OK.
- Activate the Developer tab of the ribbon (*)
- Click the Design Mode button to turn it "on".
- You can now select the combo box and edit it.
- Don't forget to turn off Design Mode when you're done.
(*) If you don't see the Developer tab:
- Click the Office button.
- Click Excel Options.
- Tick the check box "Show Developer tab in the Ribbon".
- Click OK.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: ComboBox in Excel 2007
Hans,
I found it and I appreciate your assistance as always.
Out of curiosity, why do you mention, "Don't forget to turn off Design Mode....."
Regards,
John
I found it and I appreciate your assistance as always.
Out of curiosity, why do you mention, "Don't forget to turn off Design Mode....."
Regards,
John
Regards,
John
John
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: ComboBox in Excel 2007
If you leave Design Mode on, you won't be able to use the combo box (i.e. select an item from the dropdown list)...
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: ComboBox in Excel 2007
Also I believe you won’t be able to run code while in design mode