Search : in
By :

Can vba return excel cell value with formats

Last answer on Apr 2, 2009 10:10:54 pm BST abandonedfriend, on Oct 24, 2008 5:11:19 am BST 
 Report this message to moderators

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.

Best answers for « can vba return excel cell value with formats » in :
Excel - Send value of cell to target Show Excel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Checking multiple Cell values and validating Show
How to make formula in excel cell for time? Show
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
Repainting a cell using excel VBA ShowRepainting a cell using excel VBA Issue Solution Note Issue I am writing a code in excel VBA to generate a report.I am totally new to VBA.Here's my code Private Sub CommandButton1_Click() Dim a1 As Integer Dim d1 As Integer Dim...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

tl, on Oct 24, 2008 9:52:00 am BST
  • +9

Hi,

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

This should get you started

   
Reply to tl

2

 s1w_, on Apr 2, 2009 10:10:54 pm BST
  • +2

Hint: ActiveCell.Characters(i,j) may have second parameter, length (while first is start position)

   
Reply to s1w_
Ask your question Reply
They need your help