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
Bookmarks