easy problem

[Newbie wan kenobi]

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

 

[Tom Ogilvy]

Use the sheet activate event

see Chip Pearson's page on events

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

 

[Phonio]

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