Results 1 to 2 of 2

UserForm to input data into sheet(s)

Threaded View

  1. 05-04-2016, 11:03 AM #1
    Shea2288
    Shea2288 is offline
    Registered User
    Join Date
    10-16-2014
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    16

    UserForm to input data into sheet(s)

    I have a ListBox that gets its values from each sheet name within my workbook (See picture). I would like to fill in the text boxes and have the Submit button enter the data into the selected sheets from the listbox. It could be only one sheet selected or it could be all depending on the situation. I need the program to look for the next available row and insert the data. I hope I explained that in a decent way. Thanks in advance.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Shea2288; 05-04-2016 at 11:33 AM. Reason: Added Workbook
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Check if an input in a userform is contained in a column of a target sheet
    By emymeeky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2014, 09:10 AM
  2. userform to input data
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-14-2014, 02:58 PM
  3. Dynamic updating of current userform values based on userform data input or commandbutton
    By evancharles in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2012, 06:09 PM
  4. [SOLVED] Userform only to input data to Sheet only if textbox contains data/number.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2012, 11:30 AM
  5. VBA Help need for Time sheet update besed on UserForm input.
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2011, 09:40 AM
  6. Select sheet based on userform date input
    By mugitty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2006, 05:37 PM
  7. Use userform to get input and compare to a hidden sheet
    By cwwolfdog in forum Excel General
    Replies: 12
    Last Post: 03-23-2005, 09:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1