Results 1 to 3 of 3

Thread: If Checkbox.Value=True Then VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default If Checkbox.Value=True Then VBA

    Hi everybody,

    Can anyone help me about this subject please,

    If checkbox1 clicked, msgbox1
    If checkbox2 clicked, msgbox2
    If checkbox3 clicked, msgbox3

    Example file : http://www.filedropper.com/kitap1

  2. #2
    Board Regular
    Join Date
    Aug 2016
    Location
    Denmark
    Posts
    483
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If Checkbox.Value=True Then VBA

    Hi Baggwell

    Create a new module:
    Insert -> Module

    copy/paste these codes into the module:
    Code:
    Sub Checkbox1Clicked()
    If Range("D2").Value Then MsgBox "Checkbox1 clicked", vbInformation
    End Sub
    
    
    Sub Checkbox2Clicked()
    If Range("D4").Value Then MsgBox "Checkbox2 clicked", vbInformation
    End Sub
    
    
    Sub Checkbox3Clicked()
    If Range("D6").Value Then MsgBox "Checkbox3 clicked", vbInformation
    End Sub
    Rightclick checkbox1 and select "Assign Macro..."
    Doubleclick on "Checkbox1Clicked" in the list

    Do the same for checkbox2 and checkbox3, with "Checkbox2Clicked" and "Checkbox3Clicked" respectively

    That should be it...
    Last edited by BQardi; Oct 2nd, 2016 at 06:04 AM.

  3. #3
    New Member
    Join Date
    May 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If Checkbox.Value=True Then VBA

    Thank you brother

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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