VBA DEVELOPER WORLD

Welcome to VBA Tips & Tricks. All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too Happy reading

Monday, April 12, 2010

When coding with the Worksheet events use the keyword Me.

Private Sub Worksheet_Activate()

MsgBox Me.CodeName

End Sub
Posted by VBA DEVELOPER at 9:24 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2013 (16)
    • ►  March (4)
    • ►  February (5)
    • ►  January (7)
  • ►  2012 (56)
    • ►  December (6)
    • ►  November (5)
    • ►  October (5)
    • ►  August (5)
    • ►  July (5)
    • ►  June (5)
    • ►  May (5)
    • ►  April (5)
    • ►  March (5)
    • ►  February (5)
    • ►  January (5)
  • ►  2011 (50)
    • ►  December (8)
    • ►  November (12)
    • ►  October (5)
    • ►  September (5)
    • ►  August (5)
    • ►  July (5)
    • ►  March (5)
    • ►  January (5)
  • ▼  2010 (72)
    • ►  December (5)
    • ►  November (7)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (6)
    • ►  June (5)
    • ►  May (5)
    • ▼  April (10)
      • If (condition) Then Code statement :-
      • Select/Case Statement :-
      • Looping Statement :-
      • Scrolling about a chosen worksheet.
      • Making sure the Combobox selection is part of the ...
      • Stop a user from closing a UserForm via the X:
      • When coding with a UserForm use the keyword Me.
      • When coding with the Worksheet events use the keyw...
      • When coding with the Workbook events use the keywo...
      • Prevent endless loops within events:
    • ►  March (5)
    • ►  February (5)
    • ►  January (5)
  • ►  2009 (10)
    • ►  December (8)
    • ►  November (2)
  • ►  2007 (2)
    • ►  November (2)

About Me

VBA DEVELOPER
View my complete profile
Simple theme. Theme images by luoman. Powered by Blogger.