Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop screen to appear when selecting a specific tab in excel works
Hi all,
Apprecaite your support to educate me how to have a pop screen appear when selcting a specific tab in an excel work sheet. please if this will be done using Visual basic, please send me the code and educate me how to save it on excel becuase i have never used the VBA thanks for your usual cooperation kind regrads, Khaled Shaheen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop screen to appear when selecting a specific tab in excel works
What kid of popup screen? If you just mean a message box of some
sort, you could place the code in the Worksheet_Activate of that particular sheet. Right click on the sheet tab that you want this to happen for and select "View Code". Then paste this in the VBE Window. Click on a different sheet tad and then click back on the tab you placed the code in. You should see a message box popup. If this is nopt what you are after, please provide a little more detail. HTH Private Sub Worksheet_Activate() MsgBox "Place your message here" End Sub khaled shaheen wrote: Hi all, Apprecaite your support to educate me how to have a pop screen appear when selcting a specific tab in an excel work sheet. please if this will be done using Visual basic, please send me the code and educate me how to save it on excel becuase i have never used the VBA thanks for your usual cooperation kind regrads, Khaled Shaheen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting a specific excel instance | Excel Programming | |||
UDF only works when focus is on a specific sheet - Help!! | Excel Programming | |||
UDF only works when focus is on a specific sheet - Help!! | Excel Programming | |||
UDF only works when focus is on a specific sheet - Help!! | Excel Programming | |||
Selecting specific excel charts using VBA | Excel Programming |