Open a UserForm when a Tab is selected

  • Thread starter Thread starter SJW_OST
  • Start date Start date
S

SJW_OST

I would be most appreciative if someone can help me with this.
I have a user form that I want to show when a TAB, Sheet1, is selected then
hide again when ANY other TAB, Sheet2, Sheet3, etc..., is selected. I've seen
similar posting to do this when a cell is selected but I could not get them
to work when a TAB is selected.
Thank you in advance.
 
Put the commands in the sheet's Worksheet_activate / Worksheet_deactivate
events, ot in the workbook's SheetActivate / SheetDeactivate events.

HTH. Best wishes Harald
 
Hi

Is it so that your code selects a sheet to do something there ? Selection by
code is almost never necessary, you can work there by addressing it
directly, like
Sheets("Sheet12").Range("A1:C14").Clear

Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

activate userform when a worksheet tab is selected 1
UserForm MsgBox problems 6
Worsheet selection 5
Populate a userform from a worksheet 1
Excel VBA help: Text file formatting 19
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Junp start my Select Case Macro 12
SHEE1. Duplicate all sheets, making 2 copies of ea. / 2. Add " E"and " F" to end of tab name. / 3. 3

Back
Top