Option Box

[harksteve]

I am quite new to visual basic. I have created an option box. How can I tell it to print a number say "53" into cell B6 when I click on it?

thanks in advance

[Troubled User]

In the click event in VB you would put something like:

range("b6").value = 53

"harksteve" wrote:

>
> I am quite new to visual basic. I have created an option box. How can I
> tell it to print a number say "53" into cell B6 when I click on it?
>
> thanks in advance
>
>
> --
> harksteve
> ------------------------------------------------------------------------
> harksteve's Profile: http://www.excelforum.com/member.php...o&userid=30483
> View this thread: http://www.excelforum.com/showthread...hreadid=501402
>
>