DropDown list

[magix]

Hi,

In Excel VBA coding, I would like to have a box pop up when a macro button
is clicked, similar to InpurBox, but it should be a drop-down list, instead
of edit box.

I believe there is no such function called Listbox, but there is function
called InputBox. I need to use UserForm or Control. Can you give me some
examples? etc sample code ? A simple one will do.

Thanks.

Regards,
Magix

 

[Bob Phillips]

How about Data Validation? See http://www.contextures.com/xlDataVal01.html
for a starter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)