Search Tables and add too tables

Hi, I suggest you take a look here.
It's all there, just take your time to read it, digest it and try it.
There's even a sample file.
https://www.thespreadsheetguru.com/b...t-excel-tables

What do you mean with still stuck, couldn't work it out?

Hi, may I be frank? at first look it looks great but the first thing I as an 'unknown user' would ask, what am I searching for?
You have a search form, all nice but no indication of what I should fill in here.
Then you've got a large Frame, perfect and a large TextBox that I imagine will hold the found result (or results) , is this correct?
Why not a Listbox instead.
I don't know how VBA minded you are or if this code is based on a working sample from somebody else that you adapted.

I like to make these 'tools' as clear and transparent as possible for a user so my approach would be all together in another way, yes, the forms are good, no problem there but the code in the background could use a tune-up to make it more effective but since I hate to work on assumptions I need to know what search options do you want.
The tables are all identical and that's great to get a good working code.

You've got a Part number, a description a manufacturer and a location.
It's quite simple to write some code that starts searching as you type and depending of the user did or did not select a category shows all results .
What is the goal of the search?
Know if it exists?
How many in stock?

Well the add items I assume is to add a new item to a selected category or if it exists update the stock by an entered number?
You could also have an option to all together delete an item if it's no longer manufactured or even edit the item's description and manufacturer.

As you see there are many options.

Let's stick to search and add.
What do you want the user to search for?

More things:
Sheets are missing in your sample

Please Login or Register  to view this content.

I think, and looking at your code you got this from Teach Excel and just don't know what to do, unless you forgot to copy things into this sample book for help.
This means that your post incorrectly shows what you want.
You need someone to work it all out for you and don't know how to continue.

Nothing works as you have it now so ...

Please be very specific with what you want .
This a HELP forum not a design forum for this you can ask for paid services, read the rules ...

No problem to help you with this but the DO GIVE THE CORRECT INFORMATION when asking things.

The structure you put together is good and because the layout of the tables is identical, makes it easy to use.
I'll put my idea in code and upload a file when I've finished.
Is Delete an item also an option you considered? If a part is no longer available or has been replaced by another?
Once you get started you'll see that more things and 'nice-to-have' options come by.

Hi, just for starters, the search form.
I put my code into it and the idea I would approach it.
What I want to do is include the Add, Edit (update QTY and so) , Delete in this one form
This is what I have so far, just the searching 'made easy' type anything the search bow with or without having selected a category

Hi, I think I went further than I intended, but I think you might like playing around with this one
I didn't didn't write any extra instructions but if you open the SEARCH form you'll probably be able to see how it works

I noticed you've not been on-line.
Wondering

Well I was waiting for you and here's the latest version.
I also attached a file with inconsistencies (it's also in the Search sheet)
Ad, Delete and Edit works

The Category sheets need cleaning up, putting part # together, much to do (for you )

I'm off to bed now.

Still needs fine-tuning, and not all macro's are under a button.
The Stock part doesn't work yet, You can select one and so but not make changes to the table, no code behind it all.

Can you explain the Delete thing? I checked, maybe wrong but it seemed to so the right thing.

Saw it, I checkd but didn;t do it correctly, will ammed the code and update, sorry for that

Corrected that part.
You'll be mssing one or two entries due to my testing

HI, good morning.
I have been testing the modules more seriously and found several serious bug
I've corrected these and have attached the lastest version, hopefully much less 'buggy'

I'm writing down some explanation about how the thing is built.
I tested the Add and it works here, but it can be that some things don't do it right just yet.
If you explain a little more the idea of how you want it to work (use the last update v1.1.4) and where it goes wrong indicting the steps you took, then it will be easier to see what's missing.
Just saying 'it shows incorrect' and 'delete not working' leaves me guessing since you don't say what you see and what is exactly the problem.
I dug into this because the idea challenged me to see what I can do with it.

Thanks for the compliment, I think it's like having 'played' longer with Excel and learning by doing.
It's mostly self-taught using found scripts; what you really need is time and a lot of patience to troubleshoot.
I'm hoping to finish the instruction 'manual' and will upload it together with the latest version. You see , while stepping thought the forms and writing it down I've run into some 'bugs' which I correct on-the-fly.
You'll probably run into nice-to-have options but that's a challenge for you

Hope to get it done before the weekend so you can test it.

Well, here it is, as promised.
I don't suggest you print all the code and read it.
Export the vba module and read it in a text editor like Notepad++ where you can select the code language to make it readable
Here is the PDF file I promised with the explanation (user manual) and the latest version

Try and think of coding like writing a story explaining each step as you go.

If the value i am looking for is in cell a then do this and and that else do something else.
And so on...
There is really nothing magic about it, just common sense and a lot of imagination. start by recording a simple macro and then edit it and make smal changes as you go.

That's the only way to learn, doing it and doing it once again.
My macros are not that complicated only thing is that I combine many routines and reuse many more to avoid duplicate coding.
Yes, you can print it all but it's a waste of paper, Like I said install Notepad++ and read the exported VBA projects, makes it easier
I've attached all the VBA project's content, unpack it and in a sub folder and then open the bas, frm or cls with Notepad++ (Notepad can be used too but it has not code modules)