Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro using forms button
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro using forms button
On Oct 28, 3:15*pm, "Fawn Lagimodiere" wrote:
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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message box\Forms button | Excel Programming | |||
Deactivating a Forms macro button based on a worksheet condition? | Excel Discussion (Misc queries) | |||
Assigning a macro to a forms button (help) | Excel Programming | |||
Formsbutton question | Excel Programming | |||
Option Button Macro (Forms Toolbar) | Excel Programming |