TextBox on a Form How do I.......?

[Casey]

I have a VBA Form that has a TextBox and I would like to put a copyright
mark in the text at one point, but can't seem to find a way. Is this
possible?

Thanks

 

[Guest]

Casey,

I was able to embed the © symbol in a textbox on a form using Alt+0169
(press those number keys on the number pad to the right of your keyboard)

http://HelpExcel.com

 

[Harald Staff]

The code version:

TextBox1.Text = "Casey" & Chr(169) & Year(Date)

To get the corresponding numbers to these symblos, create a character map
worksheet for yourself. In a blank sheet enter formula =CHAR(ROW()) in the
row 1 cells and fill down to row 255. Format each column with different
fonts. Arial, Marlett, Symbol and the Wingdings family are extremely useful
for those things. I think my "charmap.xls" is the file I use most often, and
this is it.

HTH. Best wishes Harald