Button text

[patnitin]

Hi,
I have some buttons in my worksheet which hide and unhide some of the columns on clicking it.I want the text to alternate between signs '+' and '-',based on whether its hiding/unhiding the columns.Inother words I want the button text to shw '+' sign when the columns are to be expanded and sign'-' when the columns are to be hidden.Such kind of application I have seen in many sheets but unable to do it my self.(kindly note the I have wrtten the code for the columns to be hidden/unhide and I want only the button text to change)

Can anybody help!
Thanks in advance.

Regards,
Nitin

 

[njimack]

Have you tried the macro recorder? This is what it produces for me

ActiveSheet.Shapes("Button 1").Select
    Selection.Characters.Text = "Hello"
    With Selection.Characters(Start:=1, Length:=5).Font
        .Name = "NewsGoth BT"
        .FontStyle = "Roman"
        .Size = 10
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ColorIndex = xlAutomatic
    End With
End Sub

Obviously, a lot of the erroneous code could be removed.