Using VBA to add people to a table using form

**jermaindefoe** · 01-13-2008, 11:52 AM

Hey peeps, ive got a table on the bottom of my spreadsheet that has names of people in, first name in a clumn, last name in a coumn marks scored in a column and overall grade in a column. Ive created and coded a form which allows a user to enter the first name, last name and points but how do i get it to add it to the table, id really appreciate the help

thanks very much

ricki lambert

ive attatched my worksheet in hope somone can have a look, as for the form that allows user entry, i havent got sa button coded to open it yet so you have to push alt + f11 to open the vba code thingy :p

**royUK** · 01-13-2008, 12:45 PM

Debug your code and you will see that your code has too many End subs (should be exit Sub) in this Procedure - Private Sub enterbtn_Click()

Try this

Please Login or Register  to view this content.

**jermaindefoe** · 01-13-2008, 12:52 PM

Please Login or Register  to view this content.

ok so would the next bit after

Please Login or Register  to view this content.

be;

Please Login or Register  to view this content.

and in ur code u have it as firstnamelbl, wouldnt it be firtnametxtb????

thanks

sorry for being dumb lol

**jermaindefoe** · 01-13-2008, 01:34 PM

ok, so thanks to the code you have posted i have managed to get it to work, i just have two things i need to sort out

q1) whenevr the detials get entered the are put correctly in to the columns, however, for the formual t owork correctly i nthe other columns the points section thats entered from the form needs to be in number format, and by right cicking the cell and changing to number doesnt work, i have to input the data i nthe form, then click the green thing that says convert this to number, then the rest fo the formulae in the othe column works

q2) how do i add a button to the worksheet that will open the user form up, i realsie the code for a normally programemd button would be something like

userform.show()

thnanks peeps

**royUK** · 01-13-2008, 01:50 PM

Change the Number Format with the code

Please Login or Register  to view this content.

Add a button from the Controls Toolbox then use

Please Login or Register  to view this content.

**jermaindefoe** · 01-13-2008, 02:21 PM

.Cells(R, 3).NumberFormat = "000"

this still doesnt convert it????

**royUK** · 01-13-2008, 02:42 PM

using your examples & my last code, the formulas work in Columns D & E, and also the Mean. I gat no number stored as text error which i think you are referring to.

You need to drag the formulas down in D & E, and amend the average formula.

**royUK** · 01-13-2008, 03:29 PM

This amendment will copy the formulas down for you

Please Login or Register  to view this content.

Using VBA to add people to a table using form

LinkBack

Thread Tools

Rate This Thread

Display

Using VBA to add people to a table using form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions