Hi Everyone
I'm making a little userform to send data to a DB, I'm using Excel 2010, I've 3 textboxes, so the question is, how I select TB1 as defect, then write a 2 or 3 digits only (1 not permitted) number, when enter select TB2 and write money amount, then when enter those numbers will be writed in TB3 (big textbox) and the focus return to TB1 to continue filling numbers and prices, when finish a command button will send all data in TB3 to the worksheet.
The data in TB3 has an ID number, this is continue and must increase by one each time that TB3 send data to DB.
I know is easy but my programming level is low and work hours trying to understad.
Also, have anybody a handbook where can I find all commands used in VBA? you know, some manual to find what properties has a commandbutton, or an enterkey in code, etc.
Thanks in advance
Bookmarks