+ Reply to Thread
Results 1 to 10 of 10

Populating problems with User Form

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Populating problems with User Form

    Hi all,

    I am running into some problems with my code for a User Form and I'm hoping to get some help.

    Currently I have it set up so that you type data into one User Form and then based on that data this second User Form pops up (so far no problems with this).

    Now when I fill out the data in the second User Form it's doing a couple of things.

    1. Only the first two lines will populate to the specified worksheet.
    2. When I run the Userform again it writes over the data (doesn't jump to the next blank cell)

    Any insight you might be able to offer into this would be greatly appreciated. I have made a working User Form with all the data that I can revert to but I'd prefer to use multiple User Forms to keep the User experience simple, compartmentalized and clean.

    Thanks!

    Wolfman


    CommandButton2 is the 'OK' button.


    Please Login or Register  to view this content.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Populating problems with User Form

    You will probably have to change the code for calculating the Rowcount2. Here's an article about prop and cons of different methods.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Populating problems with User Form

    not sure but perhaps something like that
    Please Login or Register  to view this content.
    blue

  4. #4
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Populating problems with User Form

    Quote Originally Posted by Tinbendr View Post
    You will probably have to change the code for calculating the Rowcount2. Here's an article about prop and cons of different methods.
    I took a look but am still having issues. Are you able to work through my code to give me an example?

  5. #5
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Populating problems with User Form

    Please Login or Register  to view this content.
    If this doesn't work, we'll have to see a sample.

  6. #6
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Populating problems with User Form

    This code gives me an invalid or unqualified reference error. What am I doing wrong here?

  7. #7
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Populating problems with User Form

    Quote Originally Posted by Tinbendr View Post
    Please Login or Register  to view this content.
    If this doesn't work, we'll have to see a sample.
    What do you mean sample? Sample workbook?

  8. #8
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Populating problems with User Form

    Sorry, that should be
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Populating problems with User Form

    I got this code to work but for some reason it puts a space between each entry. Any idea why?

    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Populating problems with User Form

    ok this works:

    Please Login or Register  to view this content.

+ 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. [SOLVED] Populating user form combobox with range question
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2013, 05:06 PM
  2. [SOLVED] Populating a text area in a user form from an Array???
    By rreifs68 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 08:25 AM
  3. User Form Basics - Populating Text Boxes
    By T.J. Lanza in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2009, 03:48 AM
  4. populating a listbox on a user form?
    By lrhodes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2006, 07:05 PM
  5. Populating a list box or combo box on a User Form
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2006, 08:28 AM

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