+ Reply to Thread
Results 1 to 11 of 11

How to record the information with just click one button

  1. #1
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Exclamation How to record the information with just click one button

    Notes: Do not make any adjustment on layout that already fixed in Sheet 1

    Step to record:
    1. In excel attachment, I enter the all the required details in Sheet 1
    2. Once the information fill in completed, I click "Done" button, then it will show the information (which in thick border column) in Sheet 2
    3. After that, the programme will automatically clear all the details that I fill in before in Sheet 1 but the information in Sheet 2 wouldn't clear
    4. So I can continue for another new information in Sheet 1 and then this new information will shown at the below of the last information in Sheet 2 once I click "Done" button.

    Thank you for advance.
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: How to record the information with just click one button

    Notes: Do not make any adjustment on layout that already fixed in Sheet 1
    For the attached I did make a change...You had NO "Done Button"....


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 01-06-2020 at 02:28 AM. Reason: Code amendment
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: How to record the information with just click one button

    Can you help me put the code inside the file because I didn't know how to do it?

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: How to record the information with just click one button

    Code is in the attached file of post 2

  5. #5
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: How to record the information with just click one button

    Hi can i know why my previous code unable to use along with your code or is there only one code able to use in one sheet? And is there possible to customise the "Done" button likes colour?

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: How to record the information with just click one button

    What are the actual cells that must be cleared after the DONE is pressed...
    See upload for button change
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: How to record the information with just click one button

    Sorry no need to clear the information. The last thing i need your help is fill the "Done" button into white colour and the text as well because we need print out it. Or can you teach me how to change it? Thanks for advance.

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: How to record the information with just click one button

    Or can you teach me how to change it?
    https://www.extendoffice.com/documen...of-button.html

  9. #9
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: How to record the information with just click one button

    Thank you. Can i know how to remove the shadow of button? The shadow still exists even though i already change it to FALSE

  10. #10
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: How to record the information with just click one button

    Has a default shadow effect...Why not just insert a shape and edit accordingly...Has much more formatting options...

  11. #11
    Forum Contributor
    Join Date
    01-28-2019
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    160

    Re: How to record the information with just click one button

    Thanks for your advice

+ 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. [SOLVED] How to get information from a website with the click of a button
    By hadydea in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2019, 06:30 PM
  2. Changing cell on button click pulling information from a ListBox
    By Boechat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2019, 09:22 AM
  3. Replies: 7
    Last Post: 04-13-2018, 07:38 PM
  4. Data record with the click of a button
    By madhavaraja in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2017, 01:44 AM
  5. stoping duplicate record of data with double click of macro button
    By ajleeds in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-14-2014, 10:43 PM
  6. Click a button - pass some information - How To?
    By Askjerry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2014, 05:44 PM
  7. Click a button - pass some information - How To?
    By Askjerry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 05:40 PM

Tags for this Thread

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