Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.userforms
|
|||
|
|||
![]()
In order to access the Caption of a Userform, I am passing the Userform as
an argument to a procedure. If I pass the Userform as an Object, then the code works as intended. If I pass the Userform as an MSForms.Userform, the code does not work properly. I've seen the same behavior in both Excel and Word (Office 97, 2000, and 2002, not yet tested in Office 2003). In one case, the caption is treated as an empty string. In the other case, the caption is displayed in the "body" of the Userform rather than in the title bar. See Passing Userform as an argument to a procedure (Excel and Word) at http://www.standards.com/OhMyWord/VBABugsFeatures.html -- http://www.standards.com/; See Howard Kaikow's web site. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing a UDF as an argument to a UDF | Excel Discussion (Misc queries) | |||
Passing properties to a procedure | Excel Programming | |||
Passing an argument to a quote | Excel Programming | |||
Passing an argument to a quote | Excel Programming | |||
Passing a Password to a VBA Procedure | Excel Programming |