How to create a form in Excel

[dare2live]

Just a Amateur, i would like to know on how create a form where you can feed information on daily basis and it get updated on real time on daily basis. And can be used by mutiple user.

 

[vijaySharma]

You have 2 requirements here.


1. To create a data entry form to capture the input.

2. To have another form which displays the data that have been entered.


Are you


1. Using a database to store the data / or using excel as your database


How to create a Form.


In excel (2003). go to Tools....Macro.... and then click on Visual Basic Editor

In the VBEditor.... click on Insert and then UserForm


You will be presented with a blank form to start the design...


HTH

~Vijay

 

[JP]

How about the Lists feature? It has a built-in form you can use to update a worksheet with new values.