controls cut/paste

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #16
    Originally posted by NeoPa
    Not quite right there.
    The string "Event Procedure" is stored in the property of the object with the same name as the event. So, a CommandButton would have a Click event (to handle what happens when it is clicked), so it would also have a Click property (Look in design view and see in the properties various properties with the names of events). When there is VBA code for a particular event (in this case Click), that similarly named property contains the string "Event Procedure".
    Does that make more sense. It's an ADezii Clever. He's a clever chap and comes up with various work-arounds that most of us have never thought of :)
    Hello NeoPa:
    Not being critical or nit-picky but clarifying something. For Events having corresponding Event Properties, the Event Properties are prefaced by On as in:
    [CODE=text]
    Event Associated Property
    Click On Click
    MouseDown On MouseDown
    KeyPress On KeyPress
    ... ...
    [/CODE]
    BTW, like the clever chap comment - only wish it were true! See you around, Old Chap!

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32669

      #17
      Originally posted by ADezii
      Hello NeoPa:
      Not being critical or nit-picky but clarifying something. For Events having corresponding Event Properties, the Event Properties are prefaced by On as in:
      [CODE=text]
      Event Associated Property
      Click On Click
      MouseDown On MouseDown
      KeyPress On KeyPress
      ... ...
      [/CODE]
      BTW, like the clever chap comment - only wish it were true! See you around, Old Chap!
      Hi ADezii.

      I'm going to be critical and nit-picky here (:D) and say that while that is true for a number of events it is not true for all (Before/After Update et al). It was a point worth making but I would say that, if the property is not named exactly the same then it should at least be recognisably similar.

      Now don't argue with me. You ARE a clever chap :)

      Comment

      Working...