Someplace on the same worksheet where you want the 'combo box' to appear type in one comb box selection, or row, per cell - e.g. 'apples' in cell 'A1' and 'oranges' in cell 'A2'. Select the column that you want to the dropdown to appear in - it can be the same column where the combo box selections appear. Let's say column 'A' for our purposes.
On the menubar select 'Data' and then 'Validation'. On the 'Settings' tab
Allow - change to 'List
Data - click on the right-hand side square, select the cells with your combobox selections, click again on the right-hand side squar
Click on 'okay
You can hide the row or column - in this case rows 1 and 2 - where the combo box selections occur
O
(2)Use the Toolbar Form Control's combobox
from the menubar select 'Tools' and then 'Customize'
Select the 'Commands' ta
In the 'Categories' window select 'Forms
In the 'Commands' window select 'combo box
Drag the 'combo box to your toolbar and close out of the 'Customize' bo
Click on the 'combo box' icon on your toolbar and click-n-drag the cursor in the place where you want the combo to be locate
Right-click on the combo box in your worksheet and select 'Format Control' to assign propertie
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
