+ Reply to Thread
Results 1 to 11 of 11

What is the another code to allow the other command button to click?

  1. #1
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Thumbs up What is the another code to allow the other command button to click?

    Guys,

    I use the code below to wait for 20's to run the next program.
    Is there any code to write to allow other command button to click during the 'Application.Wait...' is running?
    Please find the attachment for detail.
    Please Login or Register  to view this content.
    Thanks in advance for any small helps and efforts.

    Best Regards,
    Iqbal
    Attached Files Attached Files

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: What is the another code to allow the other command button to click?

    Can you split up the wait?

    Please Login or Register  to view this content.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: What is the another code to allow the other command button to click?

    Hi Solus,

    I am sorry late to reply due to just came back from duty.
    The things is no different if i split up the wait, because when the '.Wait..' is running, i can't click other command button.
    Appreciate for your helps.

    Best Regards,
    Iqbal

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: What is the another code to allow the other command button to click?

    Is it supposed to run every time during the wait or only occasionally?

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: What is the another code to allow the other command button to click?

    you can use doevents again
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  6. #6
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: What is the another code to allow the other command button to click?

    Hi Solus and Josie,

    Again I'am late to replied, Sorry Guys due to just came back from night shift duty.
    So i can replied on this forum after came back from duty, then i will go for sleep for the next night duty, and so on.

    Solus, this is not will run every time, but any time if need to click other command button it's supposed to be the command button can be ran, not must be wait (if it use: '.Wait...').
    Josie, I have been tried your code, but it not giving the time delay, it just running continuously.

    Again Guys, thanks a lot for your helps and advice, i will 'Add Reputation' for your efforts and patients.

    Best Regards,
    Iqbal

  7. #7
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: What is the another code to allow the other command button to click?

    gee that was a rookie mistake!
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: What is the another code to allow the other command button to click?

    Hi Josie,

    Excellent brother...thank you sooo much...
    Appreciate for your golden hands.
    I will add reputation to you, Josie.

    Best Regards,
    Iqbal

  9. #9
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: What is the another code to allow the other command button to click?

    Josie, why i could not add any reputation to you after i did yesterday?

  10. #10
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: What is the another code to allow the other command button to click?

    I think you've gotta give some to someone else first ;-)

  11. #11
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: What is the another code to allow the other command button to click?

    Or only one times allowed to give 'add reputation", or maybe I didn't read the rules carefully.
    Any how, i am really appreciated for your helps and thank you so much.
    God bless you, Josie.

+ 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. use a command button to click other command buttons
    By fcharl9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2013, 08:48 PM
  2. Need Help command button click
    By limcaitie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2013, 10:34 PM
  3. Code a Command Button on UserForm not to close upon click - Excel VBA
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-14-2012, 02:20 PM
  4. Click a command button with code
    By h_aesa1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2009, 11:03 AM
  5. Command button click code
    By mqdias in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-07-2007, 05:31 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