UserForms assistance Required

[newbie13]

Hi,

Could someone please tell me how I get my UserForm2 to be dsiplayed everytime I select a tab? (apart from on opening workbook).

Help is apprecaited.

n.

[davesexcel]

Hi,

Could someone please tell me how I get my UserForm2 to be dsiplayed everytime I select a tab? (apart from on opening workbook).

Help is apprecaited.

n.

Hi,
You could use the worksheet activate event, this goes into the worksheet module
Right click on the sheets tab and select view codes
copy and paste this code there

Please Login or Register  to view this content.

[BigBas]

Dave's suggestion is spot on. But, instead of entering that code into each sheets code, I'd use this code in the workbook code:

Please Login or Register  to view this content.

This could save a bit of time, especially if you have a number of sheets.