+ Reply to Thread
Results 1 to 4 of 4

Simple Macro To Do Button

  1. #1
    Registered User
    Join Date
    10-15-2015
    Location
    Huntington Beach, CA
    MS-Off Ver
    2016
    Posts
    14

    Lightbulb Simple Macro To Do Button

    So my need is to create a personal planner. I've thought about using One Note or other programs, but I'm comfortable working in Excel. I've tried creating buttons but am having trouble with the Macro.

    The idea : A default text box to input a task, and a button or two on the side to file it in a list.
    - I can type in Do Laundry and a button for "Done" or "To Do" and it will time stamp it and file it in a list.

    I know it is more complicated than it sounds, but I can't even get the text box and button to send the text.

    Ideally, I open up my task spreadsheet, automatically populating the text box > typing text > click button > Task filed

    Any help will be appreciated, as well as tips for simplistic formatting of the macro.

    Thanks, you guys are awesome.

    Gblack686

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Simple Macro To Do Button

    Upload your file, so we have something to work with.
    Make sure there is some sample data.

    ViewPic
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Registered User
    Join Date
    10-15-2015
    Location
    Huntington Beach, CA
    MS-Off Ver
    2016
    Posts
    14

    Post Sample File Attached

    Sample files to play with are helpful!

    Preferably export the data to the second sheet in chronological order. Ignore "zoning" sheet.

    Thanks again!
    Attached Files Attached Files

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Simple Macro To Do Button

    Ideally, I open up my task spreadsheet, automatically populating the text box > typing text > click button > Task filed
    So you want B3 on the "Input" sheet to be a drop down list of tasks?
    If so populated with data from what cells on what sheet?

    Just specify what you want to happen, please use sheet names and ranges and where you want the data to end up and what you want it to look like.

+ 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. Simple form control Macro to sort row or rows on button click?
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2014, 02:06 PM
  2. Simple macro button-Please Help
    By wls485 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2014, 01:02 PM
  3. VBA assign macro to button from a different file (simple you'd thi
    By NX3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-02-2014, 01:08 AM
  4. Simple macro button to create data - Please help
    By brandonlbrewer in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2014, 03:11 PM
  5. [SOLVED] Enable an ActiveX macro button (Should be simple)
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2012, 03:48 PM
  6. Simple Open Macro Button
    By richard05 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2009, 07:34 AM
  7. Help with simple macro button
    By IowaTracy in forum Excel General
    Replies: 3
    Last Post: 08-27-2006, 01:56 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