Populate an input box in a macro
 

Greetings all. I have a macro that uses a popup input box to promt for user
entry. Is there a way I could have the box list the possible choices, rather
than have the user manually type in a value? I have seen several ways to
make it populate with the sheet names, but that is all. Thank you.

Populate an input box in a macro
 

You need to create a userform with a combobox


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=33807