Drop-down arrow

rkd110

New Member
Joined
Jul 25, 2002
Messages
6
Does anyone out there know if there is a way to create a drop down arrow in a cell in excel. I want to restrict what entries can be put into a certain cell in my workbook, and I want the people who use this workbook to be able to choose from a list that I provide what they can input. Please let me know if you can help. Thank you!
Ron
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Lucien

Board Regular
Joined
Oct 16, 2002
Messages
131
Hi,
I think a list box or combo box is a nice solution for your problem.

1. View, toolbar, forms
2. Select a list box from the menu
3. right mouse click, Format control
4. Input range-> refer to the possible entries
5. Cel link to a cel
6. Use the numbers in this cel, using if..then statement

Hope this wil help you
 

Watch MrExcel Video

Forum statistics

Threads
1,123,079
Messages
5,599,636
Members
414,326
Latest member
kfg1287

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top