View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default 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