Data Form

jsinnr · Apr 29th, 2002, 12:50 PM

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 · Apr 29th, 2002, 09:17 PM

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 · Apr 30th, 2002, 02:32 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 12:50 PM	#1
jsinnr New Member Join Date: Apr 2002 Posts: 13	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 ]

Apr 29th, 2002, 09:17 PM	#2
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	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...

Apr 30th, 2002, 02:32 PM	#3
jsinnr New Member Join Date: Apr 2002 Posts: 13	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.