+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    07-24-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    69

    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
    Last edited by Lkivagten; 08-06-2012 at 10:17 AM.

  2. #2
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

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

    Hi,

    I think it is possible. Please check out provided workbook contained solution.
    Attached Files Attached Files
    Best Regards
    MaczaQ
    ---------------------------------------------------------------------------------------------------------------------------
    If you are satisfied with the solution(s) provided, please mark your thread as Solved
    If you are pleased with my answer consider to rate it. To thank someone who has helped you, click on the star icon below their name.
    - This way you will add him some reputation points ... thanks in advance.

  3. #3
    Registered User
    Join Date
    07-24-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    69

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

    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
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Lkivagten; 08-06-2012 at 05:56 AM.

  4. #4
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

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

    Hi,

    So,
    Quote Originally Posted by Lkivagten View Post
    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 !
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1