MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel migrating data from a spreadsheet into a custom form

Posted by IMGKC on January 14, 2002 3:27 PM

Here goes. In Excel 97 I've created a custom form (1099-MISC). Also in Excel I've created a spreadsheet containing data I need to migrate into this new form, approx. 268 records. Can it be done and how?

Any help is appreciated

Posted by on January 14, 2002 10:22 PM

In your code for the form, write code that loads the data under the UserForm_Activate subroutine. (NT)