+ Reply to Thread
Results 1 to 2 of 2

Form Button to update list

  1. #1
    Registered User
    Join Date
    08-04-2013
    Location
    Tucson, AZ
    MS-Off Ver
    Excel 2007
    Posts
    13

    Form Button to update list

    Hello,

    As you'll see I'm using a button "Next Month" to clear out what I need and start each month fresh.

    I'm trying to find a way to use another button to update the Monthly Tracker E22:E26. Ideally, if the user pressed the update button it would put add the current Total Other Asseets to the list. I would also like to keep the "next month" greyed out until the Update button is pressed but that would have to reset each time.. so that it would be inputted 5 times total (1 for each month)



    Balance Sheet YTD.xlsm

  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: Form Button to update list

    try

    Attachment 257066

    I changed your buttons slightly for ease of use.
    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."

+ 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. Creating an Update Button within Excel worksheet (non-form)
    By howieG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2012, 05:48 PM
  2. Update a form from list print to pdf and repeat 50 times
    By schlagert@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2012, 02:04 AM
  3. Filling form fields via worksheet dropdowns, user update via form, change form color
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2010, 08:58 AM
  4. Update List without closing User Form
    By Jogier505 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2010, 04:36 PM
  5. macro button for database like sheet. Update & ReSort list alphabtzd
    By DoraExplorExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2007, 01:56 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