+ Reply to Thread
Results 1 to 11 of 11

Message when VBA works; Be patien etc..; Is possible progress bar on progress information?

  1. #1
    Registered User
    Join Date
    10-26-2016
    Location
    Czech republic
    MS-Off Ver
    MS office 2016
    Posts
    39

    Message when VBA works; Be patien etc..; Is possible progress bar on progress information?

    Hello,

    Please, I need to aplly the message about "please wait" when VBA works.

    I added test file but maybe can be some problem with language localization. (I use excel in czech language)

    For example I want to see message after start of VBA via button to the end of VBA.

    The message about "please wait" is primary task. If is possible somethink like progress information can be aplied too.

    Thank you in advance!

    Martin
    Attached Files Attached Files

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Try to modify your macro to something similar as this:

    Please Login or Register  to view this content.
    I've added a time delay on the last message as with no delay it will pass so fast you will not see it.

    Alf

  3. #3
    Registered User
    Join Date
    10-26-2016
    Location
    Czech republic
    MS-Off Ver
    MS office 2016
    Posts
    39

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Hello,

    Thank you for answer.

    I copied you script.

    I am sorry but it does not work. The script only does the work but no information.

    I worry about language localization.

    Martin

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Martin

    What exactly is the problem?

    If you want to see the messages in a specific language you'll need to do that yourself, ie change 'simulation 1 waiting 2 seconds' from English to the language you want.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    10-26-2016
    Location
    Czech republic
    MS-Off Ver
    MS office 2016
    Posts
    39

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Hello,

    The problem is that if I run the script so it does nothink.

    It works like when "Application.DisplayStatusBar = True" is not used (ignored).

    I need not use czech language or translate. But I am using czech localization of excel so I worry that root cause is in language localization.

    I think that the code what sent Alf is right.

    I added screeen how is code insered in VBA.

    ***************************
    In the past another codes what helped me here works. (or after translate words like "sheet" to local language)

    In diferrent thread helped me that we created the script in own excel (UK) and sent me whole file and after it works.

    I am sorry for complication.

    Martin
    Attached Images Attached Images

  6. #6
    Registered User
    Join Date
    10-26-2016
    Location
    Czech republic
    MS-Off Ver
    MS office 2016
    Posts
    39

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Hello,

    I added screen.

    If an I right so very sorry.

    I noticed that in left down corner are messages.

    I am sorry.

    I think that I am right.

    Martin
    Attached Images Attached Images

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Martin

    So rather than the progress messages being displayed on the sheet you want them to be displayed in the status bar?

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Hello martin81,

    I would use a Userform and a Standard Module. Code for the Module could be Something like below:

    Please Login or Register  to view this content.
    Please let me know if you can make do with the attached sample Workbook?

    Regards.

    W.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  9. #9
    Registered User
    Join Date
    10-26-2016
    Location
    Czech republic
    MS-Off Ver
    MS office 2016
    Posts
    39

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Hello,

    Thank you a lot!! Perfectly!! It works!

    I did mistake that wrote "progress bar or aplication bar" and this is "popup window" (If am I right) .

    Thank you Alf you did it right but I am confused amateur.

    Thank you,

    The trhead can be closed as solved. Both scripts works.

    Regards.

    Martin

  10. #10
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    Hello martin81,

    Thank you for the feedback, glad we could help!

    Also thank you for adding to my Reputation.

    One thing I forgot was to cater for the "Esc" key. A user should not be able to cancel the action while in process. So please change you Macro Code to as below:

    Please Login or Register  to view this content.
    Kind Regards.

  11. #11
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Message when VBA works; Be patien etc..; Is possible progress bar on progress informat

    You are welcome.

    And I would also like to add my thanks for feedback and rep

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-06-2014, 10:29 PM
  2. [SOLVED] Progress Bar Down from Existing Progress Bar Up
    By iqballud in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-06-2014, 05:05 PM
  3. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 01-08-2014, 02:40 AM
  4. Bar chart or bar graph for construction progress physical progress
    By pvsvprasadcivil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 12:41 PM
  5. Management Information System-monitoring planned activities against progress
    By Renildrah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2012, 11:21 AM
  6. Progress Bar or Message Box
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2010, 01:47 AM
  7. [SOLVED] NEED Help - How to capture the Event's progress in Progress Bar
    By Sriram in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2006, 07:10 AM

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