Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Programmatic access to visual basic project via Visual FoxPro | Excel Programming | |||
Make visual basic truely visual! | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |