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


--
shnim1

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
gary_brown@ge_NOSPAM.com
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
>