Simple Search and Edit Function on Excel VBA

[eddieboyph]

Hi,

I am new to this site and I have been searching for a simple tutorial on how to do a search and edit userform on excel. I have found several examples however I am unable to understand them completely as I am new to VBA and would like to ask for help on my simple project.

I have attached the file and I am lost as to where to start. I hope you guys can help me and guide me through on how to start my Search and edit functions.

Lets say I am searching for username1 and VIP level is 17 and case type would be AC Cases. It will show the results at the bottom.

Eddy

[jolivanes]

The attachment does not mean anything to me. 4 Sheets with 1 Row of date in 2 sheets only. No explanation whatsoever.

Maybe Google for "Find and Replace" if I understand you right.

[eddieboyph]

Hi jolivanes,

The file is tracker for cases. We have account closure cases, Open cases and technical cases. I was able to add cases on each sheet. I am now trying to search for existing cases depending on the username, case type or case num.

[bakerman2]

When performing a search is there 1 result to be found or is it possible that multiple results are found ?
The reason I ask is in first case just add 7 textboxes to display result. Otherwise you have to add 7 textboxes and 1 listbox where you can select 1 of found results and then display in textboxes.

[eddieboyph]

Hi bakerman2 ,

It is possible to have multiple results when doing a search. I have updated the search interface to what I was aiming for.

[bakerman2]

First draft.
First select Case type then select either username or case number and click Search.
If there's only 1 result foud all data is automatically transferred to textboxes and comboboxes.
Otherwise click desired row in Listbox.
Make changes (never casenumber) and click Update.
Try it out and let me know where it goes wrong or you want it changed.

[eddieboyph]

First draft.
First select Case type then select either username or case number and click Search.
If there's only 1 result foud all data is automatically transferred to textboxes and comboboxes.
Otherwise click desired row in Listbox.
Make changes (never casenumber) and click Update.
Try it out and let me know where it goes wrong or you want it changed.

Hi bakerman!

You are a lifesaver! This is exactly what I am trying to achieve.

I tried using the update function but it gives me an error saying "Run time error '13 Type mismatch".

[eddieboyph]

First draft.
First select Case type then select either username or case number and click Search.
If there's only 1 result foud all data is automatically transferred to textboxes and comboboxes.
Otherwise click desired row in Listbox.
Make changes (never casenumber) and click Update.
Try it out and let me know where it goes wrong or you want it changed.

Hi bakerman!

You are a lifesaver! This is exactly what I am trying to achieve. Thank you for helping me

I tried using the update function but it gives me an error saying "Run time error '13 Type mismatch".

[bakerman2]

Explain which steps you took because everything works fine here.

[eddieboyph]

Hi bakerman2,

I downloaded the file again and now it is working!

Thank you for your help!

[eddieboyph]

Hi bakerman2,

I apologize for bugging you . The Add Tech Cases is not working and is giving me an error saying "Object Required".

Here's what I did:
-add Tech cases
-Fill in the details
-add case - pop up shows saying object Require Runtime error 424

[bakerman2]

Will get back to you later on today.(work is calling)

[eddieboyph]

Hi bakerman2,

I was able to fix it. the name of the combo boxes are different so I had to double check.

[bakerman2]

This should fixed it all.
Also Bottom Comboboxes in SearchForm are now loaded with correct lists.

[eddieboyph]

Hi bakerman2,

This is great. I have one more request. Is it possible to edit the case number as well?

Eddy.

[bakerman2]

Not as it is setup now.
That is because casenumber is now used to locate the correct rownumber of selected data.
You should have to add an extra column on each sheet in which you create a unique identifier which in turn you could use to reference the correct row of data you want to update.

[eddieboyph]

I am now trying to understand the codes.

Thank you for your help bakerman2.

Eddy