Hi
I am having trouble adapting a userform code from a previous workbook (help found on here to get that one working), i am trying to get it to initialize when the workbook is opened and to add a line and populate a table with user input, plus add a line to the table on the next worksheet and populate relevant cells,
Heere is my tinkered code
Please Login or Register to view this content.
I believe that this:
is meant to be this:Please Login or Register to view this content.
Please Login or Register to view this content.
Rory
see attached for code corrections - to be able to loop through the textboxes you can not rename them and expect a result.
note the order has to be in the sequence order of the table columns.
if you want the form to show on opening the workbook then put code in 'ThisWorkBook' module 'Private Sub WorkBook_Open() event (Newentry.Show)
Last edited by torachan; 11-08-2021 at 07:45 AM.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Thank you so much that is twice you have helped me with user forms, would i be able to copy the submit code and change to WS2 to paste in the same cells on the second worksheet?
Last edited by Nialc00p3r; 11-09-2021 at 06:01 AM. Reason: spelling
In the attached I have annotated the code that will pass the values to Sheet2.
Also placed on the form a multipage (you can use each page as a separate form), this save having multiple UserForms and makes passing variables between each.
You will note the labels and textboxes are simply named and in sequence order as per the table columns on sheet2 - then all the referencing can be looped - save long names and many rows of individual code.
Hi torachan, sorry to bother you again, is there a way to get the user form to populate the first 8 columns on ws2 at the same time?
The first form (your original) also populates Sheet2 as well (all though you only have seven common columns on this sheet)
Hi Tora, thank you so much for your help with this, i have edited the original workbook and it is writing how i want it to, the only issue i have now is the date on the second worksheet is mixing the day and month up, i cant see anything in the code that has changed and it writes to the first sheet with no issues
on your submit button find the code below and add it 'isdate' extra lines.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks