ExcelBanter - Combo Box Code

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combo Box Code (https://www.excelbanter.com/excel-discussion-misc-queries/45411-combo-box-code.html)

jd815

Combo Box Code

What is the best way to create a combo box with a list of options? Is there
specific VBA code that I should be using?

Dave Peterson

One of the easiest ways is to use Data|Validation.

Take a look at Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html
(a nice place to start)

jd815 wrote:

What is the best way to create a combo box with a list of options? Is there
specific VBA code that I should be using?

--

Dave Peterson

All times are GMT +1. The time now is 02:39 PM.