Archive of Mr Excel Message Board

Back to Excel VBA archive index
Back to archive home

Activating the built in Data Form

Posted by Lori D. on August 29, 2001 1:09 PM

I have a workbook with several worksheets in it. From a "home" page, I want a user to be able select a button and have the corresponding worksheet's data form pop up.

I don't have a lot of knowledge of Visual Basic, so if I need that, can somebody please walk me through the necessary steps?

Thanks! Lori

Check out our Excel VBA Resources

Re: Activating the built in Data Form

Posted by Richard S on August 30, 2001 12:27 AM

I have no knowledge of VB either, but have created a similar spreadsheet. I just recorded a macro. Menu Tools|Macro|Record, name it the sheet you're going to, select the sheet and place the cursor in the list, Menu Data|Form. Escape the datafrom and slect your "home" sheet. Repeat for each sheet naming the macros after the sheets. You can then create objects on the "home" sheet using drawing or whatever, identify them with the sheet name, right clic on them and assign macro.

HTH

Richard

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.