Results 1 to 12 of 12

Thread: in sheet if in the userform button ok was clicked perofm action if not then no...

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    VBAX Contributor PaSha's Avatar
    Joined
    Nov 2007
    Location
    Slovenia
    Posts
    104
    Location
    hey xld, is it posible without doing it in the user form buttom ??

    becouse now it's everything in a mess...




    what i have done is this for ex.

    If Caller = ButtonPon1 Then
        Workbooks("blabla").Sheets("MON").Activate
        Worksheets("MON").Unprotect Password:="pass"
        Range("i7").Value = Range("i7").Value +1
        Worksheets("MON").protect Password:="pass"
        If Caller = ButtonPon2 Then
            Workbooks("blabla").Sheets("MON").Activate
            Worksheets("MON").Unprotect Password:="pass"
            Range("i8").Value = Range("i8").Value +1
            Worksheets("MON").protect Password:="pass"
    and so on ...

    but when i click OK in the user form ... it changes all values +1 not only for specific button :s ...

    oh man oh man ...

    can i do it some other way?
    Last edited by Aussiebear; 06-21-2025 at 03:15 PM.
    I like to help others... but sometimes i also need help ...

Posting Permissions

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