| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined data type
hi
Is it possible to create a user-defined data type of the following example 11.1 (ie, the data type must be within 99.9 to 00.0 I know I could use a For...Next to validate a input (say A1), or If Statement, but wouldn't be far more efficient if I could use VarType function Also could someone tell me, why is it that when I test the following code in Immediate Window in VBE a=11. b=TypeName(a I get b as Double, why is it that it ain't in Single? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cant delete user defined default chart type | Charts and Charting in Excel | |||
| Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
| "User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
| Word.Document - user defined type not defined | Excel Programming | |||
| Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming | |||
Threaded Mode
