Can you hide a spinner???
 

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

Can you hide a spinner???
 

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