Hi everyone

I have two option buttons in user form1
I'm wondering what code I would need to use and where it would go
to link the that I have placed in to userform 1 to cell "A1" in
worksheet 'Material takeoff'

this is my first time with userforms and the properties and I'm just a
newbie at VBA

If option buttion 1 in the user form is selected then cell "A1" should
= 1
If option buttion 2 in the user form is selected then cell "A1" should
= 2
if neither are selected it should = 0 or blank
also the value in cell A1 to change before the userform is closed

Thanks in advance for any help


--
mav93
------------------------------------------------------------------------
mav93's Profile: http://www.excelforum.com/member.php...o&userid=31592
View this thread: http://www.excelforum.com/showthread...hreadid=517867