Userform and XL up function

[pswanie]

I have a userform1. In that i got amongst other stuff the following.
Frame within that 4 textbox. 20, 21, 22,24 then i got comandbutton10.
I need a comand that execute on comandbutton10_click event. I need it
to do the following, textbox20.value = sheet17 range b9 and column k
xlup. - . textbox21.value = sheet17 range a9 and column j xlup.-.
textbox22.value = sheet17 range c9 and column L xlup.-.
textbox24.value = sheet17 range a15 and column m xlup. Then i need the
current date and time acording to the system in sheet17 c15 and i
xlup.
Last request... A popup that inform the user if any of the mentioned
textbox are empty.

Help apreciated! Thanx guys!

 

[Rick Rothstein]

What does "sheet17 range a9 and column j xlup" mean? Do you want to list A9
followed by the contents of column J? Did you want to display the sum of
those numbers? Something else?

 

[pswanie]

i need the values in the textbox to be put into sheet17 cell a9 and allso in
sheet17 next open cell in colum l

in other words allways in a9 but every time one line down in column L


Regards



Phillip
--
Helpful advice on posting to newsgroups here...
http://www.cpearson.com/excel/newposte.htm

What does "sheet17 range a9 and column j xlup" mean? Do you want to list A9
followed by the contents of column J? Did you want to display the sum of
those numbers? Something else?

 

[Rick Rothstein]

I think you are looking for this (I'll do it for one text box as an example,
you can apply it to your other text boxes)...

With Worksheets("Sheet17")
.Range("A9").Value = TextBox21.Text
.Cells(.Rows.Count, "L").End(xlUp).Offset(1).Value = TextBox21.Text
End With

Note that I used Column L because your response to me said that, but your
original post said Column J... if it should have been J, just change the "L"
to "J")

--
Rick (MVP - Excel)

i need the values in the textbox to be put into sheet17 cell a9 and allso
in
sheet17 next open cell in colum l

in other words allways in a9 but every time one line down in column L


Regards



Phillip

 

[pswanie]

great!!! im just of to chow sumthin and wil then quit try it. but it
seems like the right thing that i need...


regards



Phillip