Results 1 to 5 of 5

Option button click with if else statment

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2010
    Location
    Portland oregon
    MS-Off Ver
    Excel 2007
    Posts
    10

    Option button click with if else statment

    I am trying to execute a program using if else statement on an option button to open a userform on a command button click. The following userforms are named as drilling, milling and so on. The trouble I am having is, the vba tell me my if else statements are wrong could some one show me the right way if i am doing something wrong

    Private Sub Ok_Click()
    
    
     If Drilling.Value = True Then Drilling.Show
     ElseIf Milling.Value = True Then Milling.Show
     ElseIf Turning.Value = True Then Turning.Show
     ElseIf Reaming.Value = True Then Reaming.Show
     ElseIf Boring.Value = True Then Boring.Show
    
    End If
    
    End Sub
    Last edited by peedarp1985; 06-03-2010 at 12:12 AM.

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