Excel VBA Userform to search multiple worksheets

[ExcelEndeavor]

First, some context...

I have a userform that users complete to capture the salesperson, product ID, product category, revenue amount, and sales date. There is a submit button that funnels the data into 1 of 5 seperate worksheets that are based on product category selected in the userform:

Industrial, consturction, maintenance, hospitality, administrative

(All of the worksheets are formatted exactly the same with the salesperson in column C - it's just to keep the categories separate)

*** This part works great ***



Now, I want to create a userform to search for the salesperson across all 5 worksheets and display the results into a listbox. Then, I can double-click one of the results to open the original userform that was completed for the details of that item and/or make edits if needed. Again, the worksheets are all formatted exactly the same, with the Salesperson in column C.

How would I accomplish this?

 

[DanteAmor]

I can't download your file.
You can share it on google drive or dropbox.
Since your file identifies it as a google sheet file.

 

[DanteAmor]

By the way, were you able to test my file and identify how I have the code in the userform?

 

[ExcelEndeavor]

By the way, were you able to test my file and identify how I have the code in the userform?

I couldn't get it to work on my end. I think I am not doing something right. I sent the share link for google drive - were you able to download the file by chance?

 

[DanteAmor]

I couldn't get it to work on my end. I think I am not doing something right. I sent the share link for google drive - were you able to download the file by chance?

I couldn't download the file. I mentioned it in post #11, you shared the link to see the file on Google, but I can't download the file.
Try uploading your file to Google Drive again.

 

[ExcelEndeavor]

I couldn't download the file. I mentioned it in post #11, you shared the link to see the file on Google, but I can't download the file.
Try uploading your file to Google Drive again.

I just added you as an editor and re-shared. Let's see if that works

 

[DanteAmor]

I just added you as an editor and re-shared. Let's see if that works

I don't see your file as macro-enabled excel, I only see it as normal excel, and I can't download it with macros, therefore I don't see the forms.

I insist, you were able to download my file. So you can see how I put the code and replicate it in your file.

Or create another copy and share the file again. But try dropbox.

 

[ExcelEndeavor]

I don't see your file as macro-enabled excel, I only see it as normal excel, and I can't download it with macros, therefore I don't see the forms.

I insist, you were able to download my file. So you can see how I put the code and replicate it in your file.

Or create another copy and share the file again. But try dropbox.

I just put it in dropbox...

Dropbox Link

 

[DanteAmor]

I already have your file

At first glance, I found that you made several changes to my code.

Let me check what else you changed and get it working

 

[DanteAmor]

I keep finding changes to my original code

I keep checking...

 

[ExcelEndeavor]

I keep finding changes to my original code

I keep checking...

View attachment 121606​

I changed it based on this worksheet - this is a budgeting sheet, which is different from the sales sheet that I was originally working on.