Dropdown VBA Code

[Smytgemm]

I would like to insert a combo box or dropdown into excel 2007 using VBA code in which I can select the options (i.e. not refering to cell already selected).
I already know how to do this the excel tool bar but I would prefer to do it straight from VBA.
Any suggestions would be much appreciated.

 

[Engineer]

I would like to insert a combo box or dropdown into excel 2007 using VBA code in which I can select the options (i.e. not refering to cell already selected).
I already know how to do this the excel tool bar but I would prefer to do it straight from VBA.
Any suggestions would be much appreciated.

Use with and .AddItem

i.e. for a combobox called Cboitems with the choices Item 1, Item 2, Item 3 your code would look like this:

with Cboitems
.AddItem "Item 1"
.AddItem "Item 2"
.AddItem "Item 3"
End With

 

[Smytgemm]

Thanks, I know what you mean but how do I actually make the original combobox?
I can't seem to find that code anywhere?