Asset REgister

[mfjanoo]

Hi

I have an Asset Register hereby I need to Add / Delete / Find / Edit Records

I managed to get the Add New Record Working.

However I seem to be having problems with Searching for Data in a sense once the Data is found I need it to be populated in the correct fields.

I appreciate it anyone can please assist with this.

Thanks

I have attached the spreadsheet

[mehmetcik]

I am an expert on userforms and search routines.

But frankly I don't understand what you want.

There are two userforms with numerous command buttons.

No one is going to spend anytime trying to guess what you want to happen.

So I suspect you will not get any help with this request.

You need to explain which macro you want us to look at

Where you want us to enter data and the data to enter.

where you want the Userform to pull the data from

And finally where to display it.

[mfjanoo]

My Apologies for not being clear


I have attached screen shot of problem. The code is in the search button.

Asset Register.jpg

[mfjanoo]

HI

I have managed to get the Search option working.

However when I try add a new record which was working before I get the following error message

"Runtime error'-2147417848 (80010108)'
Method "Value" of object "Range" Failed

I have attached spreadsheet.