Simple check box macros

[bademployee]

Hi all,

I know very little about macros, would appreciated if someone could assist with the following:



When check box 1 is checked, I want a value to appear in B4 (B3*10%) and check box 2 to become unchecked

When check box 2 is checked I want check box 1 to become unchecked and the value in B4 to clear.

Thanks for any help in advance.

Mark

 

[Smitty]

No need for a macro. I'd use Option Buttons and set the linked cell to an obscure cell, then just use a formula:

=IF(B1=1,B3*0.1,"")

The Option Buttons are tied to eachother, so the first will return a value of 1, the second a 2, both of which you can test against.

HTH,

 

[bademployee]

Great, thanks!

Mark