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("C2") = 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?''.


"shnim1" wrote:


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


--
shnim1