Francisco has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Data management
Imagine that you have 3 columns with 3 types of data to fill in (name, age, weight). You have to enter data for 100 individuals and want to create a sheet with the data. You enter data for one individual (with a form). What is the code for entering the data on one row and then entering the data of the second person (and thereon) to fill in the spreadsheet?
RE: data management
Hi Francisco
Thank you for your question
If you want to enter data manually using a form, then there already exists a standard excel form which will allow you to do this.
If however you wanted to enter data from an existing source, for example an access database then there are a whole set of tool (Active X Data objects) that allow you to do this easily. This is too involved to discuss here, but we do cover this on the VBA advanced course
Regards
Stephen
