Results 1 to 10 of 10

Thread: Help With a Simple Code Please!

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Aug 2011
    Posts
    19
    Location

    Arrow Help With a Simple Code Please!

    [vba]Dim cbo As OLEObject
    Dim ws As Worksheet
    Set ws = Worksheets("Boiler")
    If OLEObjects("ComboBox1").Object.Value = "Boiler4" Then
    Set OLEObjects("CheckBox2").Object.Value = True
    Else
    Set OLEObjects("CheckBox2").Object.Value = False
    End If[/vba]

    Can you tell me whats wrong and how to fix it please, i am trying to make it so that when ComboBox1 says "Boiler4" the checkbox autommatically ticks itself.

    thanks in advance

    test.xlsm
    Last edited by lovett10; 08-23-2011 at 12:59 AM.

Posting Permissions

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