Discussion Locked

Forms in Excel

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

3 replies

by choppit

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.

This discussion is closed to new replies.