Inserting wingding into Toggle button

[Richard]

I'm trying to get ToggleButton1.Caption = "2" to show as a 1 with a
CIRCLE around it (The 2 is just used as an example). Which is a
wingding. But it will not show up when I copy and paste. Is there a
way to either use a wingding or anything else that might work. Thanks
is advance!!!
Using excel 2010

Private Sub ToggleButton1_Click()
If ToggleButton1 = True Then
ToggleButton1.Caption = "2"
Else
ToggleButton1.Caption = "1"
End If

End Sub

 

[Suzanne S. Barnhill]

If you are actually doing this in Excel, then you might have better luck
asking in one of the microsoft.public.excel hierarchy of NGs.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Richard]

If you are actually doing this in Excel, then you might have better luck
asking in one of the microsoft.public.excel hierarchy of NGs.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org








- Show quoted text -

Thanks for your quick responce but I'm doing it in Word. I know more
about excel than word actually. Thanks anyway!

 

[Suzanne S. Barnhill]

Well, a circled 1 is character 129 in Wingdings. You'll need to specify the
font. Or you can use an AutoText entry as illustrated at
http://gregmaxey.mvps.org/Add_Toggle_Objects.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

If you are actually doing this in Excel, then you might have better luck
asking in one of the microsoft.public.excel hierarchy of NGs.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org








- Show quoted text -

Thanks for your quick responce but I'm doing it in Word. I know more
about excel than word actually. Thanks anyway!