Delete Range when checkbox in Userform is Selected

Hello all,

is there a way to delete range D4:D50 when one of the checkboxes in a userform is selected?

The checkboxes on the Userform look something like these, and got about 56 of them

Please Login or Register  to view this content.

Originally Posted by shg

Please Login or Register  to view this content.

Thank you for replying SHG.
But I guess I wasn't realy clear about what I'm trying to accomplish.

By selecting checkboxes codes are entered on the sheet which will be included in a graph.
At this moment first all codes need to be manually deleted before opening the userform.
But I'd like them to be deleted, not when the userform is opened but when the one checkbox is selected. However with your code each time a checkbox is selected the range is cleared.
While this only need to be done the first time a checkbox is selected. After some rethinking I gues this is hard to accomplish.So I will use the code to clear the contents when the userform is opnened.

Still one question though. Is it possible that when the userform is openened the checkboxes with a non-empty cell reference is checked?