Results 1 to 6 of 6

Using IF to code option buttons and list boxes

Threaded View

  1. #1
    Registered User
    Join Date
    04-07-2010
    Location
    Kings Park, NY
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Using IF to code option buttons and list boxes

    I have a spreadsheet with a list of daily job tasks that need to be put into a list box and to be counted as they are performed.

    so I want to hit a command button and change the value of a cell up and down (based on the value of the list box)
    and specify which worksheet (based on the option button selected)
    I have a worksheet for each day of the work week.
    So if option button 1 called monday is selected then i need the user form to refer to the proper worksheet..
    I have the command buttons working for a particular cell but don't know how to use the If else statements

    Please help..i know how to do formulas in a spreadsheet, but user forms programming is new to me..
    Private Sub CommandButton1_Click()
        Unload Me
        
    End Sub
    
    
    Private Sub CommandButton4_Click()
    Range("b1").Value = Range("b1").Value + 1
    End Sub
    
    Private Sub CommandButton5_Click()
    Range("b1").Value = Range("b1").Value - 1
    End Sub
    
    Private Sub ListBox1_Click()
    
    End Sub
    
    Private Sub OptionButton1_Click()
    End Sub
    
    Private Sub OptionButton2_Click()
    
    End Sub
    
    Private Sub UserForm_Click()
    
    End Sub
    Last edited by royUK; 04-07-2010 at 01:01 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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