dim adviser as string
.....
adviser = Inputbox "Enter Adviser's name"

HTH
--
AP

"cdb" a écrit dans le message de
...
I have a macro designed to move a sheet to a different workbook dependant
on
who the adviser is. At the moment I have this looking at a certain cell in
a
workbook. What I would really like is when the macro is set off an input
box
pops up and gives the options of adviser names to choose from.

If this possible, and if so how?

Cheers,

cdb