| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to format a control in a Userform
I have a Userform which has the .controlsources set to named ranges in one
of the sheets. There are 3 ranges on the sheet that are Custom formatted with leading zeros such as "000". If a 1 is entered it is displayed on the sheet as 001. However, in the form the number shows as 1. I have tried Text(<name, "000") but that doesn't take. How do I display the numbers with a custom format? Thanks. Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to pass a control to a sub | Excel Programming | |||
| Selecting control on userform with part of control name (set question) | Excel Programming | |||
| Unable to add references to Calendar control and outlook object | Setting up and Configuration of Excel | |||
| Control Sequence from Userform Control | Excel Programming | |||
| unable to control screenupdating | Excel Programming | |||
Threaded Mode
