software

Hi

I need to have a spinner control disappear until activated by another value in a cell. I was wondering weather this could be done via conditional formatting?, or that there needs to be an additional function. Thanks for help and advice

THANKS
In the worksheet module where the spin button is located, put something like...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Condition when SpinButton1 should be visible
If Range(quot;C2quot;) = 5 Then
SpinButton1.Visible = True
Else
SpinButton1.Visible = False
End If
End Sub

This could also go in ...
Private Sub Worksheet_Calculate()
Private Sub Worksheet_Activate()
or
Private Sub Worksheet_Change(ByVal Target As Range)

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;shnim1quot; wrote:

gt;
gt; Hi
gt;
gt; I need to have a spinner control disappear until activated by another
gt; value in a cell. I was wondering weather this could be done via
gt; conditional formatting?, or that there needs to be an additional
gt; function. Thanks for help and advice
gt;
gt; THANKS
gt;
gt;
gt; --
gt; shnim1
gt;