View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Superscript a character in a string

Give this a try:

Sub dural()
Dim s As String
s = "100" & Chr(176) & " longitude"
MsgBox (s)
End Sub
--
Gary''s Student - gsnu200819


"RyanH" wrote:

Is there a way to superscript a character is a string. I want this string to
be entered into a textbox. For example,

This is what I have:
tbxViewingAngle = "140 Degrees Horizontal"

This is what I want:
tbxViewingAngle = "140o Horizontal" (Superscript the "o" in the string)

--
Cheers,
Ryan