Results 1 to 10 of 10

Move userform TextBox entries to cells on a sheet

Threaded View

  1. #1
    Forum Contributor rkjudy's Avatar
    Join Date
    03-31-2009
    Location
    Longview, TX
    MS-Off Ver
    MS Office 2010
    Posts
    239

    Move userform TextBox entries to cells on a sheet

    My question is simple. I have a CommandButton on a worksheet named 'Workup' that, when clicked, presents a userform with 15 textboxes (TextBox1 through TextBox15). I have CommandButton1 on the userform also. When I click CommandButton1, I want the value in the textboxes to be placed in cell A1 thru A15 on the sheet named 'Invoice". I think it's just a repeat of the same line of code for each of the 15 TextBoxes. Once the cells on the sheet 'Invoice' are populated, I want to print the sheet 'Invoice' on the default printer. Then, return to the original sheet named 'Workup' and close the userform. The reason I'm using a userform is because the CommandButton does several other things also. Thanks in advance.
    Last edited by rkjudy; 01-10-2011 at 10:58 AM.

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