programming option button_ if errors

[napo537]

Hi, i have been looking for help and i have just don`t figured out.

I am tryin to program a userform, just for collecting inlet data in diferent cell in diferent worksheets of the same workbook. And i want to put those data dependind if the optionbutton is true or not.

I want to capture data in written in textbox8 in cell b27 of worksheet 4 if my option button is marked, and if not i want to capture the data of the textbox8 in the cell d27, both are currency type.

This is wath im trying to use:

Please Login or Register  to view this content.

[JBeaucaire]

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above and put code tags around that code you used. (Like shown in my signature)

Fix that and I'll look over your macro.

[napo537]

I have done some changes and it does not work. Ive changed to if then endif, linear form. i `ve changed to if then else end if, i `ve tryied with if then elseif end if, and i have not a clue, whats going on.

i was wondering if one problem could be that im programing on the textbox and not in the option button. im just blocked, sorry.

[JBeaucaire]

The Forum Rules.


[code] <--- that is a code tag.

[napo537]

i edit my tex, but i dont know exactly what do i need to do

1.- i put EDIT
2.- Select advanced
3.- select de code and click on wrap with tags

that was what you mean?

[JBeaucaire]

The Forum Rules.


[code] <--- that is a code tag.

[napo537]

SO, thats it or what else?

[JBeaucaire]

With no worksheet to test it on, I imagine the corrected code would look this perhaps:

Please Login or Register  to view this content.

[napo537]

Hello, it worked, now i don't have any message from an error. And it writes the value that i put in textbox8, but only in cell D27 besides that it doesn`t respect the conditional, is the same if a click on option button1 or optionbutton2, it puts in the data only in cell D27

Please Login or Register  to view this content.

[napo537]

hi, i did it, jeje, now, if i choose option button 1, y puts the data in cell b 27, and if i check optionbutton2 it writes cell D27. thasnk you very much

check this out

Please Login or Register  to view this content.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.