You need to be in the VBA editor, then right click on the left hand sid
where it says sheet1 sheet2 etc then select insert and userform, ad
your buttons and text, now for the job selection......type a list o
your jobs on a sheet highlight the range and in the formula bar on th
left hand side there is a small range window click in this and type
name for you range, now go back to your userform and in the propertie
window on the left scroll down untill you see row source then type you
list name in here, view the code for the combobox1 and typ
activecell.value=combobox1.value and on the next line type me.hide

In the code page for a worksheet select from the top dropdown bo
worksheet and from the one on the left select selectionchangenow on th
next line after sub type userform1.show.

this is the basis of the userform, have a play around with the setting
and captions to suit your needs.

Have fun!

Simo

--
Message posted from http://www.ExcelForum.com