ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I create a column that has a 'drop box' (https://www.excelbanter.com/excel-worksheet-functions/5146-how-do-i-create-column-has-drop-box.html)

Dave Simons

How do I create a column that has a 'drop box'
 
I would like to create a spreadsheet that contains a 'drop box' feature in
certain cells that allow the user to choose from a pre-described list of
values. How can I do this?

BrianB


Depending on requirements, do a search for
1. ComboBox
2. Data Validation (see menu Data/Validation)

both of which require some sort of pre-defined list in a range of
cells.


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=272940



All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com