View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default toggle button text

Hi John,

The suggested code should read:

'=============
Private Sub ToggleButton1_Click()
With Me.ToggleButton1
.Caption = IIf(.Value, "A", "B")
.BackColor = IIf(.Value, &H8080FF, &HFF0000)
End With
End Sub
'<<=============


---
Regards,
Norman