Writing option button data to specific cell in a table

**teacher_rob** · 11-11-2011, 10:14 AM

Hi all, thanks again for all your help !

I'm attempting to merge two bits of code I have recently figured out through this forum.
I want to add data from an option button (choice of 9 buttons in one frame) to a specific cell in a table based on the user's combobox selections...

this is the code i'm using to get the specific cell... SCORE would be chosen by the user in the frame with all the option buttons

Please Login or Register  to view this content.

this is the code for the option buttons, where "F11" would be the cell determined by the above code

Please Login or Register  to view this content.

i can't figure out how to nest this...

any help would be sooo much appreciated !

thanks!
-rob

**Steffen Thomsen** · 11-11-2011, 10:42 AM

Please Login or Register  to view this content.

**teacher_rob** · 11-11-2011, 11:02 AM

I'm trying this code, and i'm getting "obvject variable or with block variable not set".

not sure what that means

**Steffen Thomsen** · 11-11-2011, 11:28 AM

If the optionbutton are on a frame, then reference it

Please Login or Register  to view this content.

If its on a userform then

Please Login or Register  to view this content.

**teacher_rob** · 11-11-2011, 11:40 AM

the option buttons are in a frame. i updated the code with that in mind, but still the same error

**Steffen Thomsen** · 11-11-2011, 01:00 PM

Wich line of code gives the error?

Could you post an example workbook and i'll have a look at it!

**teacher_rob** · 11-11-2011, 01:41 PM

" If Frame1.F1opt60.Value = True Then " this is where the debugger says something is wrong...

**teacher_rob** · 11-11-2011, 01:43 PM

the code works when i'm entering in data from the text box... i'm able to select either sheet, and then fill in the appropriate cell with the info obtained from the comboboxes... when i try it with the option buttons it gets tripped up (as do I )

**teacher_rob** · 11-11-2011, 02:57 PM

ok, it's kind of working now... i realized i had cut and pasted some code from another attempt, and neglected to change the names... so the code pasted here is allowing me to enter the score corresponding to the correct option button, however, it's not letting me post to "student3" sheet... when student 3 is selected it is putting the data in "student1" sheet

Please Login or Register  to view this content.

**teacher_rob** · 11-11-2011, 03:08 PM

i think i spoke toooo soon. it is doing exactly as i am asking it to do !!!

thank you guys so much ! going to mark this is solved.

in a few hours i will be back with another question about another little bit of the big userform i'm attempting to put together !

-rob