This forum was recommended by a collegue, and I have an
easy question.

I have 3 sheets, each with a 'combobox'.

what i think i want is a 'userform' to pop up when i open
each sheet and say

"this is "

then what ever it says in the 'combobox', then

"do you want to..."

then have a choice of six command buttons linked to macros

The six macros are done, how do i make the 'userform' to
say what's above.

Thanks everyone

Use the sheet activate event

see Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Newbie wan kenobi" wrote in message
...
This forum was recommended by a collegue, and I have an
easy question.

I have 3 sheets, each with a 'combobox'.

what i think i want is a 'userform' to pop up when i open
each sheet and say

"this is "

then what ever it says in the 'combobox', then

"do you want to..."

then have a choice of six command buttons linked to macros

The six macros are done, how do i make the 'userform' to
say what's above.

Thanks everyone

Hello!

Try the attachecd file, and change to your need

Attachment filename: try this.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=43243
--
Message posted from http://www.ExcelForum.com