Hi there,

Currently a user has to enter "Y" multiple times under multiple
categories in one spreadsheet to invoke a scenario. So I have created a
UserForm which contains 9 checkboxes representing the 9 Major
categories. Each checkbox represents a number of cells under that
category. If the user selects the checkbox, I need it to fill all the
cells in the category with "Y".

How do I code one checkbox to fill a number of cells in a worksheet
with "Y" if selected?

I presume I would need the code on the OK button - is this correct?

And how do I make one checkbox represent multiple cells?

Thanks so much...


--
rbekka
------------------------------------------------------------------------
rbekka's Profile: http://www.excelforum.com/member.php...o&userid=14032
View this thread: http://www.excelforum.com/showthread...hreadid=502338

This maybe?


Code:
--------------------
private sub cmdOK_click()

If ckbOne.value = true then
Activesheet.cells(1, 1).value = "blah"
Activesheet.cells(2, 1).value = "blah"
End if

If ckbTwo.value = true then
Activesheet.cells(1,2).value = "blah2"
Activesheet.cells(2,2).value = "blah2"
End if

End sub

--------------------

etc.


--
Ouka
------------------------------------------------------------------------
Ouka's Profile: http://www.excelforum.com/member.php...o&userid=23988
View this thread: http://www.excelforum.com/showthread...hreadid=502338

thanks so much - very simple....:)


--
rbekka
------------------------------------------------------------------------
rbekka's Profile: http://www.excelforum.com/member.php...o&userid=14032
View this thread: http://www.excelforum.com/showthread...hreadid=502338