Tick Box Code

    Hi all,


    Is it possible to code that if all 5 tick boxes are ticked then an event occurs?


    I.e the user ticks the 5 tick boxes and userform 1 appears?


    Thanks in adavance!!

    Re: Tick Box Code


    Guess you would need code in the _change event of each box that checked to see if the value of all check boxes was true...something like

    Code
    If chkBox1.value = true and chkBox2.value = true and chkbox3.value = true 
and chkBox4.value = true and chkBox5.value = true then
  'Your Code
End if

    D ;)


    :sailboat: [SIZE=1]Better a bad day on the water than a good day in the office[/SIZE]

    Re: Tick Box Code


    Hi



    Put Dave's code in a Private Sub attached to Check Box 5 via Properties, View Code (right click Check Box 5)


    HTH


    Robert

    Re: Tick Box Code


    Thanks for replying Robert - wasn't being rude - just didn't have access this weekend !!

    D ;)


    :sailboat: [SIZE=1]Better a bad day on the water than a good day in the office[/SIZE]

    Re: Tick Box Code


    No, of course not...think the forum is that much better as people add their opinion and are happy to help/expand on existing threads - long live Ozgrid !!

    D ;)


    :sailboat: [SIZE=1]Better a bad day on the water than a good day in the office[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login