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


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=346868

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

"Casey" wrote:


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


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=346868

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

"Casey" skrev i melding
...

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


--
Casey


------------------------------------------------------------------------
Casey's Profile:
http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=346868