PDA

View Full Version : Adding Data Rows into excel using user inputs.



LiamAd
06-04-2012, 02:13 AM
I need to make a program in which the user can add records in a database.

For adding I would like the user to press a button on the database, and input values into text boxes (I have already set the user form up). After inputing the values into the text boxes the user then click an 'add record' button, I would like the txt boxes to be checked for blank values, then to be added to the next blank row in the spreadsheet.

Further applications I would like to add would be edit and delete functions.

Note: I am a complete beginner at VB, also the database has 20+ columns so if you could just refer to column 1 ,2 ,3 etc I will be able to figure it out :)

thanks
Liam

Bob Phillips
06-04-2012, 08:20 AM
Post the workbook with the userform.