Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    trigger the code exclusively on a single click (XP)

    I found an event that works with a single click. I remembered that Legare Coleman said "I don't know of a way to trigger the code exclusively on a single click.". I hope it even serves to you.
    <img src=/S/bouncenburn.gif border=0 alt=bouncenburn width=31 height=31>
    Example:
    Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    If Not Intersect(Target.Cells(1, 1), Sheet1.Range("A1:G10")) Is Nothing Then
    If Len(Target.Cells(1, 1).Formula) = 0 Then
    MsgBox prompt:="T

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: trigger the code exclusively on a single click (XP)

    But it isn't exclusively a mouse-click, Servando, it also triggers if you scroll into the target range using the navigation keys.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: trigger the code exclusively on a single click (XP)

    That code is going to trigger if you tab into the range, use the arrow keys to get there, press return and end up there, etc. If that is what you want, then this works fine. However, that is not what is usually meant by triggering code by a single click.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: trigger the code exclusively on a single click (XP)

    <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> You are right
    The next time, I will not hurry so much and I will think more

Posting Permissions

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