View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Insert Symbol in VBA

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


--
Gary''s Student - gsnu200765