Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting a specific excel instance Henning Winkler Excel Programming 3 July 23rd 07 10:50 AM
UDF only works when focus is on a specific sheet - Help!! Andibevan[_4_] Excel Programming 3 November 16th 05 01:56 PM
UDF only works when focus is on a specific sheet - Help!! Andibevan[_4_] Excel Programming 0 November 15th 05 09:25 AM
UDF only works when focus is on a specific sheet - Help!! Andibevan[_4_] Excel Programming 0 November 15th 05 09:14 AM
Selecting specific excel charts using VBA Mithi_M Excel Programming 3 July 25th 04 01:59 AM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"