Userform not inputting data to the correct cells

This is a continuation from a previous thread.

I now have a working userform (in sheet1) with an add and search function but it can only add and find data when the sheet layout is in a certain format. In the sample I attached, the original code works fine but the code does not work properly in Sheet2. I'm not very sure as to what I should be changing in the codes to get it to input the data to the correct cells.

One more minor annoyance...

Let's say I type in the Part Number and then the date (for eg "3-Jun-10") in the corresponding textboxes, it will put in the value "3-Jun-10" into the correct cell but when I find that part number, the date returned will be in MM/DD/YY format. How do I change it to return the exact value "3-Jun-10" ?

Thanks for the help.

Originally Posted by ScotyB

brah,

I don't know if this will help or not but on each of your user forms where the date is required, right-click each field, select view code, and add this between the sub and end sub lines...

Please Login or Register  to view this content.

It might also help if you make sure that the worksheet that has the stored data has the same format?

I'm new to vBa but have given been many handy tips here so I'm hoping I can now return the favour as I'm learning.

Cheers,

AJ

Hi AJ,

Tried out your code but the date seems to enter itself automatically into the textboxes. I downloaded the workbook I attached above just to make sure it was the same as the one I have on my desktop here but the code didn't work either. Funny thing happened though, I played with some values and I cannot replicate the problem I had earlier. But the dates are fine now, so I can't really complain Appreciate the help though man.

I still need help with the coding in Sheet 2...

bump

10 character limit

Hi Roy,

The code in userform 2 worked for me. I key in the info in textboxes 15 to 50 and they populate the correct columns (P to AY). I can't get the code to work in Sheet2 because the layout of the sheet is different. This bit of code

Please Login or Register  to view this content.

in the form tells the userform to input the data into the next empty cell in Row A but it just doesn't happen in Userform3.

Lol! Changed the Sheet2s to Sheet3s and left the "Sheet2"s as they were and it's working fine now. I don't know how I missed that. Thanks Jaslake.