Data Form

[jsinnr]

I want a Data Form for my spreadsheet just like the one you get by clicking Data>Form on the menu bar but I want to be able to edit it in VBA. Is there a way to get one without learning lots of VBA code? I'm still a beginner on VBA. Thanks.

Jason
This message was edited by jsinnr on 2002-04-29 11:51

 

[Rocky E]

Away to get started is with the macro recorder. Go to Tools, Macro and Macro Recorder. Name your macro anything for now you can change it later. Step through constructing your form and then stop the recorder. Now you can go back with Alt-F8, select your new macro and edit to see what you have done.

The VBA for Dummies book is a good starter.

HTH

Rocky...

 

[jsinnr]

Thanks. I was hoping to find a way to view (or copy) the code of the data form that Excel provides when you select a cell in the collumn name row and click Data > Form so I can add a command button with an event procedure.