ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo Box Referencing and Assignment (https://www.excelbanter.com/excel-programming/354324-combo-box-referencing-assignment.html)

Edd[_2_]

Combo Box Referencing and Assignment
 
Hi:

I would like to create a drop down box for a cell so that the user can
select one of the values listed. How can I do this?

I am not familiar with how to do other than by using a combo box. That being
the case, how would I associated item, selected, in a combo box to a specific
cell? How do I reference combo box items and assign them to a cell?

Thank you all,

Ed.



Dave Peterson

Combo Box Referencing and Assignment
 
You may find Data|Validation easier to implement.

Debra Dalgleish has some nice instructions for you:
http://www.contextures.com/xlDataVal01.html

Edd wrote:

Hi:

I would like to create a drop down box for a cell so that the user can
select one of the values listed. How can I do this?

I am not familiar with how to do other than by using a combo box. That being
the case, how would I associated item, selected, in a combo box to a specific
cell? How do I reference combo box items and assign them to a cell?

Thank you all,

Ed.


--

Dave Peterson


All times are GMT +1. The time now is 11:43 AM.

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