Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Can anyone help me find an MS Excel Form?

I am looking for an Excel form created using macros. A form that has four to five fields and a submit button. Whatever information is entered in those fields and submitted should be collected in another excel sheet.

if anyone knows a place on the internet where i can find such a form ready made, please let me know.

1 Answer

Relevance
  • 6 years ago

    One does not create VBA userforms with macros, if you are speaking of an actual userform and not simply a worksheet.

    It is possible to create a VBA userform in a workbook and export it to any specified file location. While I have not exported a form and then sent it via email to be imported, it should be doable. Do you just want the form to add to an existing workbook, or do you want the workbook containing the form?

    It would also be necessary to know which worksheet/columns you would wish the data in the form copied to.

Still have questions? Get your answers by asking now.