DropDown list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magix - 13 Dec 2005 13:48 GMT

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

Reply to this Message

Bob Phillips - 13 Dec 2005 15:57 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi,
>
[quoted text clipped - 10 lines]
> Regards,
> Magix

Reply to this Message