How to get Format of a Cell

[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.

 

[Harald Staff]

Hi Mili

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

Sub test()
MsgBox ActiveCell.NumberFormat
End Sub