General discussion

Locked

Forms in Excel

By garylewis ·
How do I create a data entry form in excel? I would like to have a button on this form to play a macro, also

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Form

by Choppit In reply to Forms in Excel

Generating a data entry form can be as easy as selecting your data columns, then selecting Data > Form. You can then add your button to the worksheet using the VB toolbar, double click the button and add the macro name to the relevant subroutine. If you want the button on the data entry form itself then you'll need to code the form in VBA.

Collapse -

by bob.jeffery In reply to Forms in Excel

Go to Data, then Form see if that works for you..

Excel 2002

Collapse -

what happened to this feature in office 2007

by david.junk.mail In reply to Forms in Excel

data form is no longer present in office 2007. how do i do this function.

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums