How can you determine if a cell is formatted as a percent?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am using VBA in Excel XP with Win 2000

I need a VBA method to determine if a cell is formatted as a percentage

Could someone please post back example code to do this?
 
Hi Quartz,
I need a VBA method to determine if a cell is formatted as a percentage.
Click to expand...

If InStr(ActiveCell.NumberFormat, "%") Then
MsgBox "Percentage"
Else
MsgBox "Other"
End If


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
You must log in or register to reply here.

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

Access Test if value is less than percent 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Enter data in cell referenced in a cell 4
Conditional format if difference in cell values greater than 0.50% 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to make a VBA Function return a value in percent format 8
Determine in VBA if a cell has conditional formatting applied 2
Date formatting in VBA 1

Back
Top