How to insert a list in the ActiveX combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl Snider - 07 Feb 2007 19:36 GMT

I have inserted ActiveX combo boxes into a form, but cannot figure out how to
insert the list of choices that will appear when I click the drop down. I am
using Excel 2000. Does anyone know how to do this?

I can create form's drop down lists and another form of drop down off the
tool bar, but I understand that if I want this data to be communicated with a
database I need to use the ActiveX control.

Signature

Carl Snider

Reply to this Message

JLatham - 08 Feb 2007 22:28 GMT

With the control shown and in design mode, click the [Properties] icon on the
Control Toolbox. Look for ListFillRange - that's where you tell it where to
get the list it displays. The LinkedCell property is where the choice made
into it can be set to be echoed on a worksheet for easier determination of
what was chosen.

> I have inserted ActiveX combo boxes into a form, but cannot figure out how to
> insert the list of choices that will appear when I click the drop down. I am
[quoted text clipped - 3 lines]
> tool bar, but I understand that if I want this data to be communicated with a
> database I need to use the ActiveX control.

Reply to this Message