Create a data entry form

Hi, I want to create a data entry form which will allow tele operators to
have a finite and user friendly set of fields to enter data that will
populate an excel sheet and then make calculations that return in the form.
More specifically I would like fields for custoemr info, what they want to
buy then based on quantities and product types return the total to teh
operator. Is there a way to do this in excel?

Cheers,

- Douglas

Hi Douglas,

Yes it is possible. There is an excellent tutorial on data forms which you
can find at http://spreadsheets.about.com/cs/exc.../vba1index.htm.

All the best!

"Douglas" wrote:

> Hi, I want to create a data entry form which will allow tele operators to
> have a finite and user friendly set of fields to enter data that will
> populate an excel sheet and then make calculations that return in the form.
> More specifically I would like fields for custoemr info, what they want to
> buy then based on quantities and product types return the total to teh
> operator. Is there a way to do this in excel?
>
> Cheers,
>
> - Douglas
>