| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform and XL up function
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! -- Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform and XL up function
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 (MVP - Excel) "pswanie" wrote in message ... 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! -- Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform and XL up function
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 "Rick Rothstein" wrote: 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 (MVP - Excel) "pswanie" wrote in message ... 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! -- Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform and XL up function
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) "pswanie" wrote in message ... 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 "Rick Rothstein" wrote: 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 (MVP - Excel) "pswanie" wrote in message ... 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! -- Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform and XL up function
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 -- Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm "Rick Rothstein" wrote: 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) "pswanie" wrote in message ... 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 "Rick Rothstein" wrote: 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 (MVP - Excel) "pswanie" wrote in message ... 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! -- Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum and Counta function in Listbox for UserForm | Excel Programming | |||
| How can I reuse function for a userform button | Excel Programming | |||
| Calling function from a userform | Excel Discussion (Misc queries) | |||
| Undo function in Userform | Excel Programming | |||
| Userform initialize combobox using Chr() function. | Excel Programming | |||
Linear Mode
