Results 1 to 3 of 3

Thread: VBA Show Message On Sheet Activate

  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    VBA Show Message On Sheet Activate

    I would like a message reminder to pop up with I select sheet "YTD"

    The message should read "Remember to select the curent month period"

    Your assistance in this regard is most appreciated

  2. #2
    Remember to select code for the YTd Sheet, Select 'Worksheet' from the drop down menu and select 'Activate' from the next drop down menu next to it.
    Code:
    Private Sub Worksheet_Activate()
    MsgBox ("Remember to select the curent month period")
    End Sub

  3. #3
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13
    Quote Originally Posted by xander1981 View Post
    Remember to select code for the YTd Sheet, Select 'Worksheet' from the drop down menu and select 'Activate' from the next drop down menu next to it.
    Code:
    Private Sub Worksheet_Activate()
    MsgBox ("Remember to select the curent month period")
    End Sub
    Thanks for the help, much appreciated

Similar Threads

  1. Test copy Activate Ribbon Tab In Excel 2007 2010 *
    By Excel Fox in forum Test Area
    Replies: 16
    Last Post: 01-22-2019, 05:05 PM
  2. Open And Activate Workbook Before Runing Macro
    By Howardc in forum Excel Help
    Replies: 5
    Last Post: 06-04-2013, 07:23 PM
  3. Display sheet names in a message box
    By pells in forum Excel Help
    Replies: 4
    Last Post: 02-13-2013, 07:33 PM
  4. Replies: 2
    Last Post: 09-25-2012, 01:30 AM
  5. Replies: 2
    Last Post: 04-03-2011, 08:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •