programming option button_ if errors

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.

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.

The Forum Rules.


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

The Forum Rules.


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

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

Please Login or Register  to view this content.

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