doctorp
12-02-2006, 10:35 AM
Hi Guys
I'm trying to write a sub to list all the custom number formats in a workbook.
I've followed the following code and it works well, to a point..
j-walk.com/ss/excel/eee/eee015.txt
However it seems to use "$" when it should be simply using $.
It also inserts a \ into the format in certain places.
I've used the code to populate a useform list and I then want to be able to delete the selected custom number formats cleanly. However I can't do this if the custom number format in the list does not exactly match the one in the workbook.
Any ideas?
I'm trying to write a sub to list all the custom number formats in a workbook.
I've followed the following code and it works well, to a point..
j-walk.com/ss/excel/eee/eee015.txt
However it seems to use "$" when it should be simply using $.
It also inserts a \ into the format in certain places.
I've used the code to populate a useform list and I then want to be able to delete the selected custom number formats cleanly. However I can't do this if the custom number format in the list does not exactly match the one in the workbook.
Any ideas?