User form closing on click anywhere except selectors

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tequilaman
    New Member
    • Oct 2007
    • 43

    User form closing on click anywhere except selectors

    I have a User Form in an Excel Calculation that I let pop up to chose several things. Now I wnat to make it close on any click outside the defined fields for chosing.

    Somehow it doesn't work with the close command, it only closes for the close buttons not for any place outside specified buttons/fields
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Kindly mention your requirment bit clearly .

    Comment

    • Tequilaman
      New Member
      • Oct 2007
      • 43

      #3
      I'ld like to close the UserForm on clicking anywhere on the form, except the specified buttons in the UserForm. It's based on Excel97, with several Add-Ins (some I wrote years ago and hardly remember what I did that time).

      The problem is that I can make it work with a button to close, but not attach it to any click on the form. I have done this before, but don't remeber how I solved it a few years ago.

      Comment

      • Tequilaman
        New Member
        • Oct 2007
        • 43

        #4
        Problem solved by multi alignment on backround definition of the form.

        I know that I solved it in a different way last time without calling the same sub on 12 conditions, but on the fast maschines these days it's not really a difference...

        Comment

        Working...