+ Reply to Thread
Results 1 to 2 of 2

one command button to work with two formula

  1. #1
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    one command button to work with two formula

    hi,

    Im back again for more learning. I have a two codes written specifically to work with 2 command buttons namely START and END. My question is can I combine two formulas or codes to work with only 1 command button?

    Here is the code for the START button:
    Please Login or Register  to view this content.
    Here is the code for the END button:
    Please Login or Register  to view this content.
    Is it possible to put together all these vba codes and make it work using only one command button? Like if user clicks on START then it will paste the time on the worksheet and make the END button appear. Then when the END button is clicked the button becomes disabled. These button will not only work once because there are a lot of users.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845
    Hi,

    If you want the "end" command button to be hidden until you click the "start" command you need to set the "Visible" Property for the "end" button to "False"
    When the userform show you will not see the "end" button. The following code is for your "start".
    Also you need to set the code for "CurRow". currently it errors out.
    I can see on your sheet that it's in row "7" so if it will always be Row "7" then you need to set the range as in the code below.


    Please Login or Register  to view this content.
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.

+ 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