PC Review


Reply
Thread Tools Rate Thread

Caption on UserForm only setting in Subclass

 
 
ion
Guest
Posts: n/a
 
      26th Oct 2006
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

 
Reply With Quote
 
 
 
 
ion
Guest
Posts: n/a
 
      27th Oct 2006
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


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
userform label.caption my.wandering.mind@gmail.com Microsoft Excel Programming 1 18th Mar 2008 08:58 PM
Userform Caption =?Utf-8?B?SmFzb24gWmlzY2hrZQ==?= Microsoft Excel Programming 2 5th Apr 2006 08:49 AM
Re: Variabel and caption in userform Tom Ogilvy Microsoft Excel Programming 3 21st Sep 2004 08:53 PM
Variabel and caption in userform Gary Brown Microsoft Excel Programming 0 21st Sep 2004 07:59 PM
UserForm Caption Soniya Microsoft Excel Programming 2 4th Oct 2003 01:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:52 PM.