Forms...Reports

[Anthony G.]

Hello to All:

A user needs to enter a name, address, DOB, SS# etc...I would presume that a form would best be suited for this., If so, then once the user clears the form and begins to enter the second set of information, could that data be sent to another worksheet, at which time the user would have the ability to view all of the data that was entered and perhaps sort that info?

If someone could just point me in the right direction, I would enjoy developing something like this.

Thanks,

Anthony

 

[bydesign]

Anthony

Everything you want to do and everything you have not thought of yet is possible...

you can have controls on the userform read data from excel and you can have information the user changes on the userform written from the userform to excel...

For example...loading data to the userform for display in a text box
txtName.text = Sheets("MySheet").Range("MyRange").value

or reverse that to dump info from the userform to excel
Sheets("MySheet").Range("MyRange").value = txtName.text

There are of course many alternatives depending on excactly what your goal is... between the people on this site and www.j-walk.com and www.cpearson.com you will find everything you need to know.

Hope this gives you some ideas...

 

[Anthony G.]

Great suggestions....thank you for pointing me in the right direction.

Happy Holiday's!

Anthony