How to get Format of a Cell

  • Thread starter Thread starter Mili
  • Start date Start date
M

Mili

Hi,
I want to display the format a perticular Cell is
using. i.e. : it may be using Number format, or General
format etcc..

How to display it in a msgbox.

Thanks

Regards

Mili.
 
Hi Mili

If the particular cell happen to be where your cursor is:

Sub test()
MsgBox ActiveCell.NumberFormat
End Sub
 
Back
Top