Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable button based on cell value
Hello,
I have created a toggle button from the Control Toolbox. The function of the button is to hide/unhide columns. What I would like to do is make the button available based on a cell's value. More specifically, what I would like to do is enable the button only if cell A1 has a value that is less than half of the value in B1. Please let me know if this is possible, and if it is, how I should do it. Thanks for any help you can provide. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable button based on cell value
Try
Private Sub Worksheet_Change(ByVal Target As Range) Dim Temp As Double Temp = Range("A1") / Range("B1") If Temp < 0.5 Then ToggleButton1.Enabled = True Else: ToggleButton1.Enabled = False End If End Sub "Shoney" wrote: Hello, I have created a toggle button from the Control Toolbox. The function of the button is to hide/unhide columns. What I would like to do is make the button available based on a cell's value. More specifically, what I would like to do is enable the button only if cell A1 has a value that is less than half of the value in B1. Please let me know if this is possible, and if it is, how I should do it. Thanks for any help you can provide. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable button based on cell value
Thanks Jim! That was exactly what I was looking for, works exactly as I had
hoped. "Jim May" wrote: Try Private Sub Worksheet_Change(ByVal Target As Range) Dim Temp As Double Temp = Range("A1") / Range("B1") If Temp < 0.5 Then ToggleButton1.Enabled = True Else: ToggleButton1.Enabled = False End If End Sub "Shoney" wrote: Hello, I have created a toggle button from the Control Toolbox. The function of the button is to hide/unhide columns. What I would like to do is make the button available based on a cell's value. More specifically, what I would like to do is enable the button only if cell A1 has a value that is less than half of the value in B1. Please let me know if this is possible, and if it is, how I should do it. Thanks for any help you can provide. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable button based on cell value
Jim,
Is there any way to adjust this macro to include another cell as well? I'm working w/ the same button, but just want to add that if cell C1 = n/a, disable the button. I've tried some combinations that I thought would work, even copying the macro and pasting it again (two of the same, w/a different range value), to no avail. Please let me know if there is anything I can do, or if I'll need to go a different route. Thank you, "Jim May" wrote: Try Private Sub Worksheet_Change(ByVal Target As Range) Dim Temp As Double Temp = Range("A1") / Range("B1") If Temp < 0.5 Then ToggleButton1.Enabled = True Else: ToggleButton1.Enabled = False End If End Sub "Shoney" wrote: Hello, I have created a toggle button from the Control Toolbox. The function of the button is to hide/unhide columns. What I would like to do is make the button available based on a cell's value. More specifically, what I would like to do is enable the button only if cell A1 has a value that is less than half of the value in B1. Please let me know if this is possible, and if it is, how I should do it. Thanks for any help you can provide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box enable and disable | Excel Worksheet Functions | |||
enable/disable macro | Excel Discussion (Misc queries) | |||
Conditional formatting based on decision to enable/disable macros? | Excel Discussion (Misc queries) | |||
Enable/Disable macros | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |