Thread: Add data with a userform

I could really use some help, I am doing a 20 hour exam for ICT and have slightly over estimated my problem solving abilities!

I really really need some help otherwise I will fail the course!

I am using the following Macro in a UserForm to enter data into a table. I have learnt the code to use in my exam but did not think what would happen if I were to move the table. I really need some help, and would appreciate someone explaining this to me.

Code:

Sub CommandButton1_Click()
    Columns("A").End(xlDown).Select
    ActiveCell.Offset(1, 0).Value = firstname.Text
    ActiveCell.Offset(1, 1).Value = lastname.Text
    ActiveCell.Offset(1, 2).Value = gender.Text
    Unload AddData
End Sub

Basically, I currently have a form at A1 to A3.
eg:
A B C
1 First Name | Last Name | Gender
2 James | Scott | Male

As it is I can add data with a UserForm and it appears at the bottom of the table.

I need to be able to move the form so it is not in A1. I have tried changing A to C, D etc. and that worked so I know how to change the column location but I need help getting the data into the table that is on a different row.

I notice Columns("A") defines the Column for the text to be placed but how do I define Row?

Please please help!

Hello AugustRush,

Welcome to the Forum!

As a new member of the forum, please take a few minutes and read the forum rules for posting and general etiquette. To see them, click on the link below...

Forum Rules

Please take note of what leith hs just posted!

Please try to edit your title now

Your question isn't clear, where is the table to write to?