Can you hide a spinner???

S

shnim1

Hi

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

THANK
 
J

jjanyan

You could use a visual basic function to do this. You can pretty much
do anything you can imagine with VB in Excel. Look around for some help.
 
G

Gary L Brown

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,
 
Top