VBA to find last row in spreadsheet - THEN find first cell that contains value

[Mike McAndrew]

Hello All

I am trying to make it simple for our shop (non-computer people) to order parts by using a userform (MachineParts) - They select a specific machine number - it populates the text boxes with part numbers, then using checkboxes, select which parts to order. This information is then stored on a worksheet (Maintenance) If a check box is checked, it stores the part number. If it is not, it stores a pre-defined "No"

From that -

I have a userform in rough construction (Place Order), that has mulitple text boxes (txtItem1,txtItem2,etc) that need to populate with values based off of the last row of another worksheet (Maintenance). I want to ignore the "No's" and only poplulate the text boxes with part number values. Thus - I need to find the last row (Which I can do) but need to search to the right - to the first cell with a part number value. Once the text box holds a value, I have figured out how to worksheetfunction.vlookup to find the rest of the information needed.

Is this even possible to search for last row, then across to first, second, third etc cell that contain part number values?

[patel45]

Please Login or Register  to view this content.

[Mike McAndrew]

Thank you patel45!

The code does work, it returns the last part number value on the row. This is working from right to left? Finding the last column in the row, then stepping back one cell at a time until it finds a value.

Is there a way to search from left to right?

[patel45]

I added comments

Please Login or Register  to view this content.

[Mike McAndrew]

Thank You! Patel45, This is perfect. :-)