ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Caption on UserForm only setting in Subclass (https://www.excelbanter.com/excel-programming/376066-caption-userform-only-setting-subclass.html)

ion

Caption on UserForm only setting in Subclass
 
Hiya.
The Caption property seems to not refer to my windowtitle if I cast my
userform to the UserForm interface. Is that clear? When I go
function example(smork as UserForm)
dim bulb as frmMine
smork.caption = "Floom" ' writes 'Floom' in Title Bar
set bulb = smork
bulb.caption = "But, I'm on the form itself!" ' writes on the form body
end function

What's up with this? I'd like to use my function against different
types of UserForms, but I'd need to be able to set the title bar.
Help!
Ion


ion

Caption on UserForm only setting in Subclass
 
Sorry, that's backwards.


function example(smork as UserForm)
dim bulb as frmMine
smork.caption = "But, I'm on the form itself!" ' writes on the form
body
set bulb = smork
bulb.caption = "Floom" ' writes 'Floom' in Title Bar
end function

ion wrote:
Hiya.
The Caption property seems to not refer to my windowtitle if I cast my
userform to the UserForm interface. Is that clear? When I go
function example(smork as UserForm)
dim bulb as frmMine
smork.caption = "Floom" ' writes 'Floom' in Title Bar
set bulb = smork
bulb.caption = "But, I'm on the form itself!" ' writes on the form body
end function

What's up with this? I'd like to use my function against different
types of UserForms, but I'd need to be able to set the title bar.
Help!
Ion




All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com