Converting a number to text using FORMAT in VBA, using a cell number format
Posted on 2011-05-11
I am trying to populate a textbox in a user form with a number from a cell in a worksheet. The format of the source cell will vary and can include some custom number formats. I want to try and use the actual numberformat property of the cell when formatting the number as text in the textbox. Is this possible? I don't think the formats used in the VBA Format function are able to directly use the cell numberformat property (or am I wrong?), but is there something clever I can do that doesn't involve an inordinate amount of coding that will achieve this?