Having option buttons fill in data conditionally

**cowboy713** · 12-07-2010, 12:03 PM

So I've developing an SSQ questionnaire for a piece of research I'm doing. When it's all done the participant will be able to enter in their data and in theory the choices selected using the option buttons should drop the data directly into the appropriate cell. Now theres 40 participant and each does a total of 8 SSQs, so the wait I'd like to set this up is on the first sheet "SSQ Data Entry", have the experimenter be able to enter the appropriate matching values in Session #, SSQ, and Particpant #, and then have the button option data fill in the corresponding area in either sheet 1 or sheet 2. Any idea how to enable this in a macro?

I've provided an attachment with the excel file if anyone wants to look at it directly.

Thank you.

**cowboy713** · 12-07-2010, 02:33 PM

anyone who can help?

**cowboy713** · 12-07-2010, 03:15 PM

I can set it up to fill in an area and then just transpose the values over the appropriate columns but can't figure out a way to set up and if statement correctly to insert the button responses based on the if statement.

Also, anyone know how to change the values being generated by the buttons? I've tried switching between the form control and active X control and can't seem to figure this out, I need the buttons to generate 0,1,2,3 and they only want to generate 1,2,3,4. Tried to do a cell reference with a -1 to the sum of the cells and that was unsuccessful as well...

**cowboy713** · 12-08-2010, 11:23 AM

morning bump

**CRIMEDOG** · 12-08-2010, 11:30 AM

Also, anyone know how to change the values being generated by the buttons?

Use Radio Buttons - It will put a value in selected cell.

**CRIMEDOG** · 12-08-2010, 12:00 PM

Use Group Box to group the Radio Buttons - then you will get a value for each row.
Then maybe a Command button on the Page Named Enter Values - with a macro assigned :
If Session # is ""
Else ...

**cowboy713** · 12-08-2010, 01:07 PM

Aren't radio buttons named "Option Buttons" in excel?

**cowboy713** · 12-08-2010, 01:08 PM

It was working a little goofy, used an index and a copied data row but its good now

**CRIMEDOG** · 12-10-2010, 05:59 PM

How about add a column that is =Option Button results-1?

Having option buttons fill in data conditionally

LinkBack

Thread Tools

Rate This Thread

Display

Having option buttons fill in data conditionally

Re: Having option buttons fill in data conditionally

Re: Having option buttons fill in data conditionally

Re: Having option buttons fill in data conditionally

Re: Having option buttons fill in data conditionally

Re: Having option buttons fill in data conditionally

Re: Having option buttons fill in data conditionally

SOLVED Re: Having option buttons fill in data conditionally

Re: Having option buttons fill in data conditionally

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions