Thread: 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

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I've added the Code Tags,make sure that you read the Forum Rules before posting again.

Attaching an example workbook would help