Hello , any help will be appreciated
i have a toggle button to hide four columns and it is working just fine .
i Have the caption on that button to return the sum of four cells , the sum is showing the number without a $sign.
what should i add to have the return number formatted with $ sign .
Thank you
Private Sub ToggleButton1_Click()
xAddress = "H:H, Q:Q, Z:Z, AI:AI"
If ToggleButton1.Value Then
Application.ActiveSheet.Range(xAddress).EntireColumn.Hidden = True
ToggleButton1.Caption = " "
Else
Application.ActiveSheet.Range(xAddress).EntireColumn.Hidden = False
ToggleButton1.Caption = Sheet33.Range("H37") + Range("Q37") + Range("Z37") + Range("AI37").Value
End If
End Sub
Bookmarks