How to Populate a spreadsheet from a Userform
I have made a userfrom and populated it with data. I want to import that data created into a spreadsheet.
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 307 guests online.
New Excel Experts
Current Excel / VBA Jobs |
How to Populate a spreadsheet from a UserformI have made a userfrom and populated it with data. I want to import that data created into a spreadsheet. |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Without seeing the user form
Without seeing the user form or spreadsheet it is difficult to get specific
Normally how you do this is with a macro, in which you select the data you want from the userform and copy and paste it to the spreadsheet, usually found on another worksheet.
It is not hard to do, assuming you know visual basic(VB).
If you do not know VB, send me the file and I can look at it and assess the VB code for you
You can email me at
marty.mjlconsulting@gmail.com
Marty