Option Box
 

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

Option Box
 

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