Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear option buttons **MACRO TWEAK**
Hello, I have the current macro assigned to clear the contents of
unlocked cells. What I would like to do is also include the clearing of 2 Option Buttons as well. Thanks for your assistance! Private Sub CommandButton1_Click() Dim cell As Range For Each cell In ActiveSheet.UsedRange If cell.Locked = False Then cell.MergeArea.ClearContents Next End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear option buttons **MACRO TWEAK**
activesheet.optionButtons("Option Button 1").value=0
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message ups.com... Hello, I have the current macro assigned to clear the contents of unlocked cells. What I would like to do is also include the clearing of 2 Option Buttons as well. Thanks for your assistance! Private Sub CommandButton1_Click() Dim cell As Range For Each cell In ActiveSheet.UsedRange If cell.Locked = False Then cell.MergeArea.ClearContents Next End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear option buttons **MACRO TWEAK**
On Feb 16, 3:34 pm, "Bob Phillips" wrote:
activesheet.optionButtons("Option Button 1").value=0 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message ups.com... Hello, I have the current macro assigned to clear the contents of unlocked cells. What I would like to do is also include the clearing of 2 Option Buttons as well. Thanks for your assistance! Private Sub CommandButton1_Click() Dim cell As Range For Each cell In ActiveSheet.UsedRange If cell.Locked = False Then cell.MergeArea.ClearContents Next End Sub- Hide quoted text - - Show quoted text - Thanks. Where would I encorporate this command into the macro? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear option buttons **MACRO TWEAK**
Depends when you want it cleared, but I would guess after the Next
statement. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message ups.com... On Feb 16, 3:34 pm, "Bob Phillips" wrote: activesheet.optionButtons("Option Button 1").value=0 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message ups.com... Hello, I have the current macro assigned to clear the contents of unlocked cells. What I would like to do is also include the clearing of 2 Option Buttons as well. Thanks for your assistance! Private Sub CommandButton1_Click() Dim cell As Range For Each cell In ActiveSheet.UsedRange If cell.Locked = False Then cell.MergeArea.ClearContents Next End Sub- Hide quoted text - - Show quoted text - Thanks. Where would I encorporate this command into the macro? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear option buttons **MACRO TWEAK**
On Feb 17, 3:11 am, "Bob Phillips" wrote:
Depends when you want it cleared, but I would guess after the Next statement. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message ups.com... On Feb 16, 3:34 pm, "Bob Phillips" wrote: activesheet.optionButtons("Option Button 1").value=0 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message roups.com... Hello, I have the current macro assigned to clear the contents of unlocked cells. What I would like to do is also include the clearing of 2 Option Buttons as well. Thanks for your assistance! Private Sub CommandButton1_Click() Dim cell As Range For Each cell In ActiveSheet.UsedRange If cell.Locked = False Then cell.MergeArea.ClearContents Next End Sub- Hide quoted text - - Show quoted text - Thanks. Where would I encorporate this command into the macro?- Hide quoted text - - Show quoted text - Cool. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRUE/FALSE MACRO using Option Buttons | Excel Discussion (Misc queries) | |||
Option Buttons with macro and working with 2 workbooks | Excel Programming | |||
Option buttons: How to get the selected option from a group? | Excel Programming | |||
Can someone please tweak my Macro? | Excel Discussion (Misc queries) | |||
No control for option buttons, invisible macro?? | Excel Programming |