I have a userform set up, and I have a database where it populates my responses once they're submitted.
However, it overwrites the responses each time instead of writing them on the next open row.
I am a VBA novice and pieced together the code from other sites, so I'm really stuck.
Heres what I have so far, if anyone has an answer I would be really greatful:
Please Login or Register to view this content.
Last edited by ConneXionLost; 11-12-2011 at 03:37 PM.
Sorry!Originally Posted by jmk8602
Please Login or Register to view this content.
I actually used a reply from another thread, and I think it worked. It was just really hard to find a reply that fit my needs (searched a dozen or so pages worth of threads), so sorry for the double post!
Your code will fail if the activecell is not within the data.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks