copyright symbol in text of a label in VBA
 

Hi,
I have a userform that I'm using for an Excel project. I have
a label in the userform and would like to put a copyright symbol
in the label. I have not been able to figure out how to do this in
VBA. Any help?

Thanks,

Jeff Melkonian

copyright symbol in text of a label in VBA
 

Use Chr(169)

strVar = "Product Name" & Chr(169) & "Blah blah blah" - Piku

--
Message posted from http://www.ExcelForum.com

copyright symbol in text of a label in VBA
 

Hi Jeff,

Label1.Caption = "Copyright " & Chr(169)

Cheers
Andy

wrote:

Hi,
I have a userform that I'm using for an Excel project. I have
a label in the userform and would like to put a copyright symbol
in the label. I have not been able to figure out how to do this in
VBA. Any help?

Thanks,

Jeff Melkonian

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info