Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
Problem with displaying characters in excel sheet
I an excel sheet, I am displaying a character alpha "?". But when I retrieve
this chaarcter though a messagebox function in VB editor, say msgbox mysheet.cells(4,5) then it shows "a" and not alpha... What am I missing ? TIA. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
Problem with displaying characters in excel sheet
How a character displays is depenent on the font used to display it.
Perhaps you want to use a Userform/textbox or label to display it since that would allow you to specify a font to display it with. -- Regards, Tom Ogilvy "Noee" wrote in message ... I an excel sheet, I am displaying a character alpha "?". But when I retrieve this chaarcter though a messagebox function in VB editor, say msgbox mysheet.cells(4,5) then it shows "a" and not alpha... What am I missing ? TIA. |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
Problem with displaying characters in excel sheet
Thanks for the response Tom.
But I specifically want to display this charater in a messagebox. Do you mean that I can do it with a textbox but not with a messagebox ? If yes, what font do I use to show it in a textbox or label ?? Thanks for your time !! "Tom Ogilvy" wrote in message ... How a character displays is depenent on the font used to display it. Perhaps you want to use a Userform/textbox or label to display it since that would allow you to specify a font to display it with. -- Regards, Tom Ogilvy "Noee" wrote in message ... I an excel sheet, I am displaying a character alpha "?". But when I retrieve this chaarcter though a messagebox function in VB editor, say msgbox mysheet.cells(4,5) then it shows "a" and not alpha... What am I missing ? TIA. |
#4
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
Problem with displaying characters in excel sheet
What font is used to display it now.
In your email, the character is shown as "?" (a question mark). I suspsect that is not what we are talking about. Anyway, in your userform, set the font property to the font being used in the cell. You can't change the font in a msgbox dynamically - at least not with the built in properties provided (you may be able to do it using Windows API calls). -- Regards, Tom Ogilvy "Noee" wrote in message ... Thanks for the response Tom. But I specifically want to display this charater in a messagebox. Do you mean that I can do it with a textbox but not with a messagebox ? If yes, what font do I use to show it in a textbox or label ?? Thanks for your time !! "Tom Ogilvy" wrote in message ... How a character displays is depenent on the font used to display it. Perhaps you want to use a Userform/textbox or label to display it since that would allow you to specify a font to display it with. -- Regards, Tom Ogilvy "Noee" wrote in message ... I an excel sheet, I am displaying a character alpha "?". But when I retrieve this chaarcter though a messagebox function in VB editor, say msgbox mysheet.cells(4,5) then it shows "a" and not alpha... What am I missing ? TIA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get excel to load data from a multiple sheet displaying | Excel Discussion (Misc queries) | |||
Problem displaying recordsets in Excel Format | Excel Discussion (Misc queries) | |||
Displaying mathematical characters | Excel Discussion (Misc queries) | |||
How to rename Excel Sheet with more characters? | Excel Discussion (Misc queries) | |||
VBA: Error displaying special characters | Excel Programming |