Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have several characters in a cell, for example "7432". I chose text format
so that I could underline one of the characters, for example the "3". How do I find out programmatically that the 3 is the character that is underlined? Assume that the value is in Cells(2,1). I know a loop is involved and I don't have too much trouble programming but I don't see something that will tell me the format of a specific character. Here's some code I started: Function FindUnderline(ByVal MyNumber) Dim l_length As Integer l_length = Len(Cells(2, 1)) Dim l_Position As Integer Dim l_String As String For l_Position = 1 To l_length l_String = Mid(Cells(2, 1), l_Position, 1) Next l_Position End Function Thanks for you help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting # of characters before a certain character | Excel Discussion (Misc queries) | |||
Finding/counting a given character within a cell | Excel Worksheet Functions | |||
Finding a character type within a cell | Excel Worksheet Functions | |||
inserting a character amongst characters in a cell. | Excel Programming | |||
Finding the first few characters in a cell | Excel Programming |