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