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

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

Perfect!
--
Cheers,
Ryan


"Gary''s Student" wrote:

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

Ryan,

You cannot superscript a character in a textbox, but you can use the degree character:

tbxViewingAngle.Text = "140" & Chr(176) & " Horizontal"

HTH,
Bernie
MS Excel MVP


"RyanH" wrote in message
...
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