Using IF to code option buttons and list boxes

**knightrdrx** · 04-07-2010, 12:59 PM

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..

Please Login or Register  to view this content.

**royUK** · 04-07-2010, 01:00 PM

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

**royUK** · 04-07-2010, 01:02 PM

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

Attaching an example workbook would help

**knightrdrx** · 04-07-2010, 01:05 PM

sorry! thanks..it's my first post..and i'm at work

**knightrdrx** · 04-07-2010, 01:24 PM

I attached the spreadsheet if that helps...
What i'm doing is creating a clicker to tally things as u go instead of writing marks on paper and then entering them in at the end of the day

**knightrdrx** · 04-07-2010, 02:38 PM

i don't need the option buttons if i put this form on each worksheet. But do i have to write a line of code for each value in the list box?
I want the program to see the current selection in the list box and refer to the proper row in the spreadsheet where it is listed.