Excel and VBA

  • Thread starter Thread starter Jippo
  • Start date Start date
J

Jippo

Hi there,
I'm just a starter with VBA, and couldn't find any 'better' Newsgroup for
my question.

I have an excel workbook with just one sheet.
in Row 1 there are the titles.:
Date, Sum, Explanation.
I'm trying to do an Userform with what to feed this information.
Can't figure out what code it is which transfers for instance 1000 ? into
B2, then next time to B3 and so on....

I know it's a lot to ask, but is there anyone there who could help me to
start?

Sorry my english

-jippo-
 
Range("B65536").end(xlup).Offset(1).Value = Userform1.Textbox1.Text
Or, just get the row & use it in all your columns, like:
Rw=Range("B65536").end(xlup).Offset(1).Row
Cells(rw,1).Value=Userform1.Textbox2.Text
Cells(rw,2).Value=Userform1.Textbox3.Text
Cells(rw,3).Value=Userform1.Textbox1.Text
HTH
Bob Umlas
Excel MVP
 
Back
Top