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.
|