I have some VBA that I cobbled together some years ago with much help, needless to say, I vaguely remember what is what. It's an asset management sheet that has a button (Check OUT) function that I would like to check for the existence of the user input provided in TextBox2 in this workbook and if a match is found, return a message stating "Equipment already out" and do nothing else.
If using Check IN Check for the presence of the user input and if found it's supposed 'to copy all of the row associated (except the column D "Location" data) with the found entry as well as TextBox1 input. This would result in the backup sheet containing the original date/time stamp from column A, original name from column B, original equipment ID from column C, the name that is "Checking IN", and generate another date/time stamp.
As of right now, it copies the entire row to the external workbook you'll see cited as AssetBKUP.xls. I tried tweaking it on my own to add the extra date stamp but I'm fumbling at best I think and I am not just trying to minimize the damage. Attached is a screenshot of what it should look like in the bk-up workbook and the file itself.
P.S. when opening type "open" in the name box to make the sheet visible.
Bookmarks