Results 1 to 3 of 3

Transfer Data From Userform to Worksheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2010
    Location
    Adelaide, Australia
    MS-Off Ver
    Office 365
    Posts
    176

    Transfer Data From Userform to Worksheet

    Hi all,

    with little or no experience in VBA, I have been able (barely) to set up a user form to display data based on some named ranges on the Dropdowns sheet.

    Names is a combo box
    Date is a text box
    Core Skills is a combo box
    Topics is a combo box
    General Comments is a text box
    Instructor is a combo box

    I figured out to get the cancel button on the user form to work but, even after searching the intertubes for examples, can't get the data to transfer from the user form to the spreadsheet via the 'submit' command button, with each record being transferred to a new row - I seem to get a lot of 'runtime' errors or 'object not found' errors.

    I apologise if this has been covered before but could someone help with this one?

    Cheers,

    AJ
    Attached Files Attached Files
    Last edited by ScotyB; 01-21-2012 at 07:13 AM.

Thread Information

Users Browsing this Thread

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

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