If it's just one item from a list of 25 (or more), you may want to put it on a
worksheet and just use Data|validation.

Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xlDataVal01.html

Moretakitty wrote:

Hi!

I am a complete newbie to VB and I am running MS Office 2000. (My VB
college class was in 1994 or something like that) I have been looking
for 3 days for complete code to do this, and I am having no luck. Even
went to the local bookstore and looked for a book... searched numberous
websites...

I started in Word and wondred if it would be easier in Excel?

I was creating Forms in Word. This excalated to someone needing a form
with a selectible list of well over 25 items. Hence I fell into the
world of VB again.

Does anyone know of any resources? I have been searching for 3
days...and I do not know enough to put pieces together of different
code.

Any assistance at all would be appreciated!

Moretakitty

--

Dave Peterson