Insert Symbol in VBA

  • Thread starter Thread starter Gary''s Student
  • Start date Start date
G

Gary''s Student

Can I insert a symbol in VBA just as I can in the worksheet with:

Insert > Symbol...

I would like to enter code like:

Sub symenterx()
ActiveCell.Value = "∰"
End Sub

rather than:

Sub symenter()
ActiveCell.Value = ChrW(8752)
End Sub
 
Yes. I used

Sub symenterx()
ActiveCell.Value = "£"
End Sub

I entered the UK pound sign with ALT+0163 (on number pad)
Not sure what code give your symbol
best wishes
 
Thank you. Using ALT+0163 enters pound symbol in both the worksheet and in
VBA. I tried ALT+3333 in the worksheet and got the Club symbol from a deck
of cards. This did not work in VBA.

I guess the ALT+ method can only be used for a subset of symbols in VBA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a symbol using VBA 6
vba macro that allows insertion of symbols at cursor 0
Control of cell comments lsot in Office10 1
symbols in VBA 4
End If 4
Worksheet_change error 2
block characters 4
Active XText box vbcr shows symbol instead of an actual carraige return 2

Back
Top