Hi all,

I am developing a rudimentary, and what I intend to be a very simple inventory program to track my IT assets within my company, I won't have more than 500 items to potentially track so I'm trying to eliminate the need for a database program or some overly-complex system.

WHat I want to do is create a VB Form in Excel that has a text box, and when something is input into that text box (A simple value from a barcode scanner) the input is put in, and then searched for in my Spreadsheet and any values that I would like to display are displayed in corresponding text boxes, or I can manually input values in and then have a button to either save the data to a new record or row in my spreadsheet or delete it from the spreadsheet.

how do I do this? I'm completely lost.

I'm a novice Office user, and Novice code-writer at that so any help would be apppreciated.

Thanks!