I have two textbox's that the user enters values into. I want the first textbox value to be put into the last column of a specific spreadsheet. I want the second textbox value to be put into the cell immediately below that cell. Currently, I have:
Does anyone know what I am doing wrong?
Please Login or Register to view this content.
cells(1,Lastcol).value = Textbox1.Text
Try the above
Elegant Simplicity............. Not Always
You are setting LastCol to the Address of the last column, it should be the Column of the last column.
Try this, it should work but I'm not sure it'll actually do what you want.
It'll put the value from TextBox1 in the 1st row of the last column and Textbox2's value in the next empty cell in the last column.
Are you sure that's right?
Please Login or Register to view this content.
If posting code please use code tags, see here.
That did work, but I want it one more column over. I think I can manage that though. Thanks!
Do you mean you want customer in one column and part number in the next, or vice versa?
So right now it is changing the last column's first row and adding to the last cell. I want it to place the first textbox's value in a new column, after the last used one. Then have the second textbox's value directly below this.
Customer in one column, part number right below it
On which row?
The second one. The point of this userform is adding a new sutomer, so there will not be any existing parts underneath it.
The 2nd row, always?
Yes. Second Row. Column that has the value of TextBox1, which is the new customer
For some reason no matter what adjustments I make, it continues to replace the last column (in the first row) that has a value with the textbox1.value. And then it adds textbox2.value to the first empty cell in that column. Any idea what is happening?
Guess what I'm going to ask you?
Go on guess.
Give up?
Could you attach a sample workbook?
Haha I sure can Norie!
It is the NewCustomerUF and it is the CommanButton1_Click() Subprocedure
Correct Document.xlsm
Why are you looking for the last column?
Don't the customer and part# go in specific columns?
Mind you, the only sheet I've found so far with Customer and Part # columns is Schedule, which doesn't appear in the code for NewCustomerUF.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks