Hi all!
Totally new to VB and have created a userform (attached) that when completed populates a worksheet. This works well but I'm having trouble linking the active serial number to the user form. I've managed to display a static value, but I need this to change when the next row is active?
Can anyone take a look?
Alternatively, is there a way for the userform to generate the serial number and add to the worksheet?
All help would be greatly appreciated!
Paul
Last edited by pj2412; 07-20-2015 at 02:25 AM. Reason: Problem Solved
Hi pj2412
Welcome to the Forum!!!
Try this for the Userform Initialization Code:
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thanks John, code worked a treat!!
Paul
You're welcome...glad I could help. Thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks