urgent please - on checkboxes

[rbekka]

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...

[Ouka]

This maybe?

Please Login or Register  to view this content.

etc.

[rbekka]

thanks so much - very simple....