Help! Userform VBA to find data in cell and insert into 2 cells over to right.

Hello all,

I have a userform that has 1 txt bx. The process of the userform is for a person to insert a device # then click on command button. I need vba code to have that userform search and find the last row that contains that device # and insert the same device# 2 cells to the right. THe purpose of this is a "check out / check in" program. I have the "check out" part done which is a seperate userform but struggling with the "check in" userform to perform this task.

The "check out" column will contain the device # then next column to the right will auto timestamp then the next column will contain the "check in" device # (which is the same) and the column right of that will have a timestamp.

So both columns with have the same device # but will show timestamp when it was checked out and then different timestamp when checked back in. This is all contained in same row.

Any question let me know. I can send you the work book if needed.

Thanks for your help on this,

MG

Hi MG3,

Better to attach your Sheet so that everyone can understand. and code based on your needs.

Hello
I'm not great with VBA but after a little messing around, maybe this code on your 'CheckInHandheld' user form 'Enter' command button:

Please Login or Register  to view this content.

Hope this helps.
*Note I should really have put some comments in the code but it's getting late here and my Brain Hurts!
DBY

Yes, the bottom two lines before the End Sub (in red).