Results 1 to 4 of 4

Auto selecting Option Button

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2012
    Location
    Mount Pleasant, WI
    MS-Off Ver
    Excel 2010
    Posts
    23

    Auto selecting Option Button

    I have a set of 8 option buttons that I'm trying have auto selected dependent on the textbox value (which is automatically populated from a cell value). The code below does not auto populate the option buttions. Any ideas?

    Private Sub TextBox1_Change()
        If TextBox1.Value = 101 Then
            OptionButton1.Value = False
            OptionButton2.Value = True
            OptionButton3.Value = True
            OptionButton4.Value = False
            OptionButton5.Value = True
            OptionButton6.Value = False
            OptionButton7.Value = False
            OptionButton8.Value = True
            OptionButton8.Value = True
            OptionButton9.Value = False
            OptionButton10.Value = True
            OptionButton11.Value = True
            OptionButton12.Value = False
            OptionButton13.Value = False
            OptionButton14.Value = True
            OptionButton15.Value = True
            OptionButton16.Value = False
        End If
                
    End Sub
    Last edited by pike; 01-22-2012 at 12:14 AM. Reason: fix code tags for newbie

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1