can it be done in excel?

S

sam

Can we create forms in excel that would populate the corrensponding fields in
excel sheet? Also if we could create forms, can we make certain fields to be
mandatory?

Thanks a Lot in advance
 
J

JLatham

The answer to both questions is yes.

You can create 'forms' in a couple of ways - either setting up a worksheet
as a form where you would enter the data, with underlying VBA code (macros)
to validate the entries and populate the fields on other sheets. Or you can
create UserForms that do exactly the same thing, pretty much in the same
fashion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can this be done? 1
can it be done in access? 5
Excel compatible freeware? 4
Forms, fields and tab order 1
about pivot table 1
Dynamic Excel data into locked Word form 0
mandatory fields in a word form? 2
data populated multiple times through excel form 5

Top