Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Optional" output of a Public Type record
Hi,
I have subs and functions that take in and update public type records. No problem when: Sub Name(InRec As uTypaA, more args..... Is there a way to optionally write a public type ? VBA won't allow: Sub Name(Arg1, Arg2, optional uRec As uType = ??? I guess since there's no constant value to assign to the fields. I get the late bound error msg when I tried this: Sub Name(prior args....., optional uRec as variant = "") Dim uWantRec As KnownType uRec = uWantRec I can guess VBA must know the Type to initialize the fields. Is it the same thing by making the public type I want one element of a ParamArray ? It seems a waste to put the "As KnownType" in the argument list, not optionally, and then sometimes update the fields, and sometimes not. Is that the best there is to optionally update and output a public type record from a sub or function ? Thanks, Neal -- Neal Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bunch of "yes" or "no" entered in row, output 1 if a single yes | Excel Worksheet Functions | |||
Where is the toolbar with the "bold type", "font type", options | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |