Degree Symbol

[Anonymous]

Hi All,

Does anyone know an easy way to put a degree symbol (ie. 45°) into a label
of a form in VBA?  I got one in by placing one in word and then cutting and
pasting it to the label, but is there an easier way?

Thanx,

Rob

[Anonymous]

Rob,

form.label.caption = 45 & chr(186)

Ben Rand

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Rob Outman" <
href="mailto:routman@nakata.com">routman@nakata.com> wrote in message

href="news:27EEFFB600B2DEF713221E3258030368@in.WebX.maYIadrTaRb">news:27EEFFB600B2DEF713221E32580......

Hi All,

Does anyone know an easy way to put a degree symbol (ie. 45°) into a
label of a form in VBA?  I got one in by placing one in word and then
cutting and pasting it to the label, but is there an easier way?

Thanx,

Rob

[Anonymous]

Rob,

hold Alt key, type 0176

(on number keypad)

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Ben Rand" <
href="mailto:Ben_Rand@email.msn.com">Ben_Rand@email.msn.com> wrote in
message
href="news:A57FE2016E54D3487B5F1E23A6D45806@in.WebX.maYIadrTaRb">news:A57FE2016E54D3487B5F1E23A6D......

Rob,

form.label.caption = 45 &
chr(186)

Ben Rand

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Rob Outman" <
href="mailto:routman@nakata.com">routman@nakata.com> wrote in message

href="news:27EEFFB600B2DEF713221E3258030368@in.WebX.maYIadrTaRb">news:27EEFFB600B2DEF713221E325......

Hi All,

Does anyone know an easy way to put a degree symbol (ie. 45°) into a
label of a form in VBA?  I got one in by placing one in word and then
cutting and pasting it to the label, but is there an easier way?

Thanx,

Rob

[Anonymous]

Or alt 248 (keyed in on numeric keypad)

Kevin Terry wrote:

 Rob,hold
Alt key, type 0176(on number
keypad)

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">"Ben
Rand" <Ben_Rand@email.msn.com>
wrote in message news:A57FE2016E54D3487B5F1E23A6D45806@in.WebX.maYIadrTaRb...Rob, form.label.caption
= 45 & chr(186) Ben
Rand

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">"Rob
Outman" <routman@nakata.com>
wrote in message news:27EEFFB600B2DEF713221E3258030368@in.WebX.maYIadrTaRb...Hi
All, Does anyone know an easy way to put a degree symbol (ie. 45°)
into a label of a form in VBA?  I got one in by placing one in word
and then cutting and pasting it to the label, but is there an easier way? Thanx, Rob

[Anonymous]

Thanx Everyone!

Glad to see I now have several ways of "getting the
job done".

Rob

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Tom Craft" <
href="mailto:tcraft1@uswest.net">tcraft1@uswest.net> wrote in message

href="news:3AF0B276.743EFAF1@uswest.net">news:3AF0B276.743EFAF1@uswest.net...

Or
alt 248 (keyed in on numeric keypad)

Kevin Terry wrote:

 
size=-1>Rob,hold Alt key, type
0176(on number
keypad)

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">"Ben
Rand" <
href="mailto:Ben_Rand@email.msn.com">Ben_Rand@email.msn.com> wrote
in message
href="news:A57FE2016E54D3487B5F1E23A6D45806@in.WebX.maYIadrTaRb">news:A57FE2016E54D3487B5F1E2......
face=Arial>Rob, 
size=-1>form.label.caption = 45 & chr(186) 
face=Arial>Ben Rand

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">"Rob
Outman" <
href="mailto:routman@nakata.com">routman@nakata.com> wrote in
message
href="news:27EEFFB600B2DEF713221E3258030368@in.WebX.maYIadrTaRb">news:27EEFFB600B2DEF713221......Hi
All, Does anyone know an easy way to put a degree symbol (ie. 45°)
into a label of a form in VBA?  I got one in by placing one in word
and then cutting and pasting it to the label, but is there an easier
way? Thanx, Rob