PDA

View Full Version : Solved: Take Userform data to new worksheet



MRichmond
01-17-2012, 07:41 AM
Cant seem to see how to unsolve a thread, so I'll post again with link to original thread

http://www.vbaexpress.com/forum/showthread.php?t=40498

As stated, I thought it was working ok, but on further testing I can only seem to get issue number one to be sent (even though file name is saved correctly).

After looking it appears that the logNo which is being used to populate the form (in A1 on Issue Cust Type 1) is not changing with the record change on the user form.

If I can get that little bit to work, then I think we can call it job done.

Any idea how to get the value from txtLogno (on user form) into cell A1 on all of the Issue sheets?

Bob Phillips
01-17-2012, 08:04 AM
See other thread.