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.
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!
Bookmarks