Are defined Excel Date and Time formats stored in a collection / enum

[SBendBuckeye]

Hello all,

Are the defined Date and Time formats in Format, Cells stored in a collection or enumeration or otherwise available programmatically? I need to test a cells formatting and make some logic decisions based on the same if I can.

Thanks in advance for any ideas and / or suggestions!

 

[PHV]

Have a look at the NumberFormat property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SBendBuckeye]

Hello PHV,

Thanks for the response! I wasn't very clear in my question. Is there a way to iterate through the list you see when you click Format, Cells, Date or Format, Cells, Time? Thanks again!

 

[SkipVought]

Selecting in a menu is not a defined event.

Changing a range format is not a defined event.

Skip,

_[red][/red]