Visual Basic
 

I am trying to write a simple VB program to enter names into a data base. I
have a column labeled names. I have made a UserForm with a TextBox called
names and a command button named Enter. I would like to type a name in the
TextBox, press Enter and the name be inserted into the first available row.
I have been able to cobble up a techinque to do this but I feel that there
may be a simpler way. My way is to go to the top of the table, do an End
Down which puts me on the last name. I then check the row number, add one
and and insert the name at that row. When I do this manuall, I do an End
Down Down but I have not been able to do figure out how to do this in VB.

Where can I find what xl commands are available?

Visual Basic
 

Range("A1").End(xldown).offset(1,0).Select

--
Regards,
Tom Ogilvy



"Ely" wrote:

I am trying to write a simple VB program to enter names into a data base. I
have a column labeled names. I have made a UserForm with a TextBox called
names and a command button named Enter. I would like to type a name in the
TextBox, press Enter and the name be inserted into the first available row.
I have been able to cobble up a techinque to do this but I feel that there
may be a simpler way. My way is to go to the top of the table, do an End
Down which puts me on the last name. I then check the row number, add one
and and insert the name at that row. When I do this manuall, I do an End
Down Down but I have not been able to do figure out how to do this in VB.

Where can I find what xl commands are available?