Results 1 to 10 of 11

Thread: Command Button to update the multiple line items in a TextBox

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    14
    I have made some changes/additions to your code. I hope this is what you are looking to do.
    1. Created a text box for COB_Date
    2. Put code behind cancel button
    3. Put code behind clear button
    4. Added code to OK button to clear text boxes after update.
    5. Set tab order of events to follow the order of the text boxes and command buttons.
    6. Added a command button to load the data from the text boxes to the commentary.
    7. Set the properties in the commentary box for multi-line to TRUE

    I did notice that the commentary box does not go anywhere. It is not saved to any particular location on your spreadsheet. Is this an oversight?
    Attached Files Attached Files
    Last edited by alansidman; 10-16-2013 at 08:55 PM.

Similar Threads

  1. Replies: 14
    Last Post: 06-27-2013, 10:57 AM
  2. Replies: 2
    Last Post: 04-17-2013, 11:53 PM
  3. Print VBA cancel command not working
    By Tony in forum Excel Help
    Replies: 1
    Last Post: 02-07-2013, 07:09 PM
  4. VBA - Split command
    By Rasm in forum Excel Help
    Replies: 1
    Last Post: 09-15-2012, 06:26 AM
  5. Replies: 7
    Last Post: 08-08-2012, 10:24 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •