Thanks guy's did the job.
Having problems with setting the Combo Box to look at the Row Source but
will persist a bit before aksing for help.
Regards

Corey....

"Bob Phillips" wrote in message
...
assign a macro to the button, and in the macro,. add

Userform1.Show

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Corey" wrote in message
...
I have no experience with Userforms and combo boxes, but think they will
assist me in achieving what i am trying to do.

I have formatted a Userform with a combo box, but :

How do i activate it from the worksheet ?

I generally use the 'Asign macro' to buttons etc. BUT the userform and
combo
box does not show is the list of macro's.

How do i asign the userform to run/display from a button etc ?

Corey....