Is it possible to do a comm.button with scrolling caption /changing caption?

Hi all
Is it possible to do a comm.button with scrolling caption /changing caption?

Like a comm.button that shows : report problem -> changing to: suggest new idea -> changing to: share knowledge. And the make this loop over and over again ? I should still be able to press the button a activate a send mail function . Is this possible at all ?

Thanks in advance
/jan

Hi,

I think it is possible. Please check out provided workbook contained solution.

Hi Maczaq

Thanks for looking into this.

Your excel file look excellent and is excactly what i was looking for. I have tried to build it into my excel file but cant get it to work.

I have 2 userforms: one is called "SPID" and one is called "userform1" .

The userform1 is the splashscreen and SPID is the main userform that shows up after the splashscreen and this is where i want the changing caption button to be.

I only have one module called module1

When i try to build in your code the best i can get is no errors but also no "caption changing commandbutton1" !?

Can you help me out?

Also.. if i may ask you that much...
How do i get the splashscreen to start in the middle of the screen both horizontal and vertical ?

And when i start up the program the first i see is the screen with my sheets (its mostly blue) and then the splashscreen and then the mainwindow (SPID) . Can i hide the sheetsscreen? - so only the splash screen is shown and then the main window? (looks more professional i think) .

And last... Is it possible to get both the splashscreen and mainwindow to autofit different screens/ resloutions? ( i have made the program to fit my screen but i know that other users will have different screens/resolutions.. is this possible?

I know this were alot of questions and i understand if its too much - and if so i would be very happy just to get changing caption commandbutton issue solved.

I have uploaded an example picture and my excel file.

Thanks in advance

/Jan

Hi,

So,

Originally Posted by Lkivagten

The userform1 is the splashscreen and SPID is the main userform that shows up after the splashscreen and this is where i want the changing caption button to be.

I only have one module called module1

When i try to build in your code the best i can get is no errors but also no "caption changing commandbutton1" !?

Can you help me out?
/Jan

I updated your file, so now it should works for your button i SPID userform (at the bottom of it's code there is an update).
I also add one module 'moduleExcelForum' there is procedure for timer ;-)

For your other questions I have only ideas becaue it is to big case for solve it for you.
If you want to hide your sheets consider to use this property of Sheet. You can also hild as VeryHidden (unable to unhide from Excel; only by VBA).
You can also make a XLT (excel addin). This kind of document have always all sheets hidden.

You can center any userform using userform's property "StartUpPosition". There is setting for "CenterScreen" and for "Center Owner". You decide what is the best for You.

Regarding resolution I can't give you any fast way. I have only one idea but it will be very hard. To check users resolution then re-build all controls using (width, height, top and left) You have quit complicated userform so it could be very hard to do. But I belive in You

Cheers !