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 a UserForm use the keyword Me.

Private Sub UserForm_Activate()

MsgBox Me.Name

End Sub
Posted by VBA DEVELOPER at 9:25 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.