Thread: From VB6 how to determine if an Excel cell string containssuperscript?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default From VB6 how to determine if an Excel cell string contains superscript?

Superscript and Name are properties of the cell font.
Superscript returns True or False and Name returns the Font Name...
MsgBox Range("B6").Font.Superscript & vbCr & Range("B6").Font.Name

Note: "Name" has various uses in Excel. It can be an object or a string.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




wrote in message
I am reading contents of an Excel file from a VB6 program. How do I
know if a string from a cell contains superscript or different fonts
(such as Greek letters)? Thanks.
Reply With QuoteReply With Quote