Format Excel cell

F

Forrest

What is the correct syntax to format (currency, percent, etc.) an excel cell from VBA?
 
R

Rod Gill

Hi,

Try recording a VBA macro in Excel of you doing the formatting you want. You
can then copy it to your app.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
Forrest said:
What is the correct syntax to format (currency, percent, etc.) an excel
Click to expand...
cell from VBA?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Change the colour of a neighbouring cell 6
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Cell data entering slow! 0
Place picture in Excel cell 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Word macro that can call cells out of Excel for a find and replace 0

Top