macro using forms button

[Fawn Lagimodiere]

Hi

I have a spreadsheet that I have used a forms button with the check mark for
making a selection. How would I write a macro to make a range of cells
blank if one of the options is chosen.

Eg. The document I have is business card order form.

If the one sided option is selected I want the cell range K8 - L12 to appear
blank.

thanks for your help

 

[Don Guillett Excel MVP]

Hi

I have a spreadsheet that I have used a forms button with the check mark for
making a selection.  How would I write a macro to make a range of cells
blank if one of the options is chosen.

Eg.  The document I have is business card order form.

If the one sided option is selected I want the cell range K8 - L12 to appear
blank.

thanks for your help

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."