Thread: How to programmatically access Number Format String in the Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xiao xiao is offline
external usenet poster
  
Posts: 3
Default How to programmatically access Number Format String in the Format
Hi,
We know that Excel allows us to format a cell in the €śFormat Cells Dialog€ť.
Then in the program, we can get the format string using
((Range)ActiveSheet.Cells[1, 1]).NumberFormat.
My question is:
Is there a way to programmatically access all the Number Format String in
the Format Cells Dialog without selecting each format manually?
Thanks,


Reply With QuoteReply With Quote