LinkBack URL
About LinkBacks
Hi All,
I am trying to get values from a userform input into columns; every time I put a new value into a new userform, the results should shift over to the next column. The code in question is below.
Please Login or Register to view this content.
Hi All,
I am trying to get values from a userform input into columns; every time I put a new value into a new userform, the results should shift over to the next column. The code in question is below.
Please Login or Register to view this content.
Last edited by Leith Ross; 04-19-2017 at 08:38 PM. Reason: Added Code Tags
Hello Don,
Welcome to the forum!
From your code it appears that the parts are in column "A" of the "Parts_Tracker" worksheet. Assuming you want to add a new part at the end of the column if it does not exist then this code should work for you.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
Thanks for replying! I think that we might have gotten our signals crossed however; essentially, the userform in question is using a combobox to select a part, input a quantity in a text box beside it and is using the found.offset command to input the correct quantity beside the correct part. However, while I am managing to get the number to find the correct cell, everytime there is a new entry it will only overwrite in the same cell (First entry into B2, second entry goes into B2 instead of C2)
Hello Don,
This will place the quantity in the next empty cell to the right of the part number on the same row.
Please Login or Register to view this content.
Hi Leith,
Thank you so much! It works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks