Combining UserForm Controls

Good Day,

I am struggling to combine procedures from 3 user forms into 1 user form.

I have the main form to add and amend data, I have a second user form to search and a 3rd to view.

I have added the search into userform1 and added the list view from the other form, however I cannot get them to all sync/work with each other.

I want the search to list the results in the list view and when I click on the list view item it will populate the form.

Each works fine when on different forms but I cannot figure out how to combine them onto 1 user form?

I am not an expert and have really been struggling.

Attached find a copy of my workbook.

Is anyone able to assist?

Thank you...

If 'real estate' is the issue, you can store large numbers of controls on a single user form by using the multipage control - that just effectively adds 'pages' to the userform, and you can switch between them by click on a tab.

Having had a very quick look though, I wonder if you might be experiencing problems because the bulk of your code seems to be stored within each of the actual userforms - you really want to try and avoid that as much as possible, not least because userforms are by default private (class) modules and the code in one is not easily accessible (nor properly accessible) from outside that particular userform. The better approach would be to store the code in standard modules, and then call those functions/subs from the relevant userform (where appropriate). Does that make sense?

Thank you… unfortunately I have no idea how to do that, I’ve tried the tab thing but it’s been too difficult, I’ve basically built all this code over 2 years taking bits from here and there…

I don’t suppose you could?

I’ve tried taking templates of UserForms with tabs and I still can’t get it right so I’ve stuck with what I have as it works. It would be so much better within 1 form.. and the list below with a search would be impressive.

What do I do? 😭

I do understand what you mean by storing it in modules. Thanks and well noted.

Hi torachan. Thank you, you have actually helped many times and I have been going through your examples and those in other posts. Unfortunately, I cant seem to understand how to adapt what you've done into my workbook - it never works and I'm not understanding how to.

My formula in the 'record' column is used to add/amend/track records, this was created by a friend who unfortunately is no longer around and therefore cannot help me with my workbook. I'm not sure how to replace the way he used the formulas to track in and out records.

The conditional formatting - I have tried and asked for help turning it into code with no solution, I have no idea how to and I need to have it, if it could be in code instead great, but I cannot figure out how to do that.

I would absolutely love to have multipage but my VBA knowledge has come to its limit and I have no clue how to adapt any of your lovely examples into my user forms.

Okay, I have made a few changes, added multipage and put a few things on one - Most is working.

My issue now is the data at the bottom of my userform seems to change based off other controls that i use - How do i make the data stay without any changes even if i 'clear' the userform?

My code looks messy too - easy way to clean it up?

Hi torachan - Sorry about that.

I wish I could start again but I just dont have the knowledge to do so - I can create the userform interface, not the coding behind it :/

I mentioned above, I had a friend who put it together for me, I've amended it here and there but he did most of the code - unfortunately he's passed away and so I cant even ask :/

Would it be a lot to ask if I create the form and you can assist in the code? - I do feel like that is a bit much to ask but I dont know where else to turn.