Previous Topic Next Topic

Can vba return excel cell value with formats

Closed
abandonedfriend - Oct 24, 2008 at 12:11 AM
 Nosi - Aug 1, 2010 at 06:12 AM
Hello, I have entered text "ABCDEFGHI" into an Excel cell. I have changed the font of "DEF" to bold. Is there a way for VBA to return the value in the cell along with formatting information.
Sample cell content:

ABCDEFGHI

Thank you.

2 responses

Answer 1 / 2
tl
Oct 24, 2008 at 04:52 AM
Hi,

information of each letter is found with this parameter:
ActiveCell.Characters(i).Font.Bold 'i is index

This should get you started
13
s1w_
Apr 2, 2009 at 05:10 PM
hint: ActiveCell.Characters(i,j) may have second parameter, length (while first is start position)
0
Answer 2 / 2
Nosi
Aug 1, 2010 at 06:12 AM
hi my friend I think it is working try it:

this is for fixing cells and return the value of the cell to the original:

function fixit(cell)
if not cell.hasformula and not isempty(cell) then
fixit=val(cell)
end if
end function
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses