Toggle option buttons to switch numbers

Hi,
I need help to toggle between % or $ down payment. I can input % then calculate the % of a loan.
When I click $ option button, I want the $value to switch in the first row, % in second row.

Thanks

See attached

The result is not is not exactly what I need.


1. If I click % option button,
D7 I enter 5.00%,
D9 will show a calculated value $1000.

2. If I click $ option button,
D7 will automatically change from % value/unit to $1,000,
D9 will atomatically change to 5.00%.

The steps are the same if $ button is first picked, $1000 will type in D7 , 5% will show in D9.
Click % button, then D7 will show 5.00%, D9 will show $1,000. Basicly D7 and D9 incliding
the unit symbols switch back and fore.

Hopefully I explain it right.

Hello
Check attached
I am new to vba
Sorry if this was not what you required...

Thanks, it works but there is a pop-up message ....
Run-time error '1004';
Method 'Range' of objects'_Globe' failede.

If you are new in VBA, I am just an infant. Please advise if you can eliminate the pop-up
or welcome who may offer help.

Thanks all!

Here's my effort, you'll have to change the locations for rngBaseValue, modeCell and otherCell to match your worksheet.
I've reworked the display a bit in my attachment.

Please Login or Register  to view this content.

I just noticed an error.
Line 32 needs to be changed.

Please Login or Register  to view this content.

Alternately, you could use the Change event so that there's no need to toggle.

In the attached, on Sheet2, C1 is the base amount. If the user enters dollars in C3 or percentages in C5, the other will adjust its value.

Please Login or Register  to view this content.