I have a user form written in VBA on the Master Sheet (top one). All I need is to get the user form data to populate into the Master Sheet. It seems like it would be easy but I don't even know where to begin.
NaughtyList 0820.xlsm.
I have a user form written in VBA on the Master Sheet (top one). All I need is to get the user form data to populate into the Master Sheet. It seems like it would be easy but I don't even know where to begin.
NaughtyList 0820.xlsm.
tel us which fields of the userform in wich fields of the sheet
kind regards
Leo
Thinking about what you just asked, I realized I just want the exact same fields on the worksheet as are on the form. You can see that the worksheet currently has the tasks individually laid out, but I think it would be just as well if the Field would copy "task 1" into the cell on the worksheet. In the end I would just like to have the individual records stack up forever, but not make the nurses scroll down to find the next blank line. I hope that makes sense. I would like the worksheet reflect an exact copy of the completed user form. If that can be done than I can do the rest.
Thank you
perhabs this exemple helps you to see how transfers from userform
to worksheets go.
I did not use the master sheet, instead the transfer go to sheet test.
Kind regards
Leo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks