Item in ListBox (search) to populate UserForm with values

Any help, please

I hope you had a refreshed weekend, and feel motivated to assist me with tackling this issue!

I am yet to make progress on this issue......

Hi..

I had a quick look.. maybe this might help..

1. You have duplicate values in Column A... it might be better to make it so the Listbox is filled with only Unique items.

Try this code.. it uses the value from the Listbox as an autofilter Criteria.. then all you need to do is extract the values form the correct cells and place them in into your textboxes..

I have done the first 2 for you.. that should give you an idea...

Please Login or Register  to view this content.

You will need to add this UDF into a Module (it finds the first Visible row after autofilter)..

Please Login or Register  to view this content.

Hi guys, would appreciate some input. I have uploaded my workbook on previous post. Post #6 contains what I would like to achieve.

Thank you all!

Hi..

So basically.. you want to update each rows cells with the values entered into the Userform for any existing GUID?

That should be just a matter of inserting the values in the first visible row after auto filter..

The Workbook you attached has most of the Userform values getting inserted into the incorrect cells..

Example.. the Userform "Company" field is being inserted into the "Site" column.. and most others are jumbled up also..

Try fixing those field allocations first and reattach your Workbook.. it adds a layer of confusion when testing when all the fields are not populating with the correct data.

hey apo. I have updated the form with correcting fields now being updated.

"So basically.. you want to update each rows cells with the values entered into the Userform for any existing GUID?"

Yes. This is to serve as a "database maintenance" feature, or for corrections.

One thing; will it be possible to remove or switch "on" and "off" the auto filter when one has finished with a search and update of a row? i.e. when one is not searching or has finished searching, the whole database is visible without a filter?

thanks!

Hi..

Try the attached file..

The correct record now gets updated.. you nearly had it right.. just needed to find the first visible row after autofilter..

One thing; will it be possible to remove or switch "on" and "off" the auto filter when one has finished with a search and update of a row? i.e. when one is not searching or has finished searching, the whole database is visible without a filter?

Adding this..

Please Login or Register  to view this content.

to your "Save" button, "Clear" button and "Close" button sorted that out..

apo, you rock! thanks!

yet one more thing (I know, I know!): When one search and there is NO possible match, how can I get a msgbox to pop-up with the option: "Create new record?" using vbYes and "Continue your search?" for vbNo?

Hi..

Add this..

Please Login or Register  to view this content.

directly below your Dim statements in your ListBox3_DblClick code..

That will stop the error if you double click on empty space..

When one search and there is NO possible match, how can I get a msgbox to pop-up with the option: "Create new record?" using vbYes and "Continue your search?" for vbNo?

I don't see the point in that.. the Listbox populates with possible matches.. so if there are none.. all the User has to do is press the Clear button and enter a new record or type a new search criteria in the textbox..

Thanks.

I don't see the point in that.. the Listbox populates with possible matches.. so if there are none.. all the User has to do is press the Clear button and enter a new record or type a new search criteria in the textbox..

Make sense to you and me, but end users..... I will just train them properly!

thanks for all your help!