VBA Help with Inventory manager (without a userform)

[BRUNO21]

Afternoon All, Anyone bored and want to help me!(Stuck for days)

I have pics of the project I'm working on.
I am trying to make a macro that would take(when clicked) the contents of "ADD PICTURE", (the text box below it) and enter it into the correct "Picture column"
I have linked my code, and my first macro worked perfect. (the text boxes in Col J and P)- but having no luck trying the same with the add picture. appreciate any and all help.
Not sure what to do bc i can't just say, put contents in the last row of col "o" due to; not every test mate having a pic.
If there's a better way of writing the code, I'm all eyes/ears. hopefully this makes sense. essentially all i need is to have it where someone would enter data into the blank white cells, and it would save to the corresponding place below.
ps. some fields might be blank and i was thinking of putting a - , as a place holder so program doesn't insert data wrong. but could not figure it out
I need it to keep all data in the table together, across columns I-Q(anyone know of a way i could sort by TC number greatest to least, or vice versa, *but with out mixing up what goes together. ie; HF-58 needs to stay with all data to the right; MFG part number etc,manufacturer,pin/socket...etc)
Not sure what to do bc i can't just say put contents in the last row of col "o" due to not every one having a picture.

 

[BRUNO21]

Kind of. Looks at the entire table by going down each row in the TC/HF column and looking for matches to the desired TC/HF number. If a match is found, it will add "image.png" into the Picture column of that row. Do you just want "image.png" to be added to the last row? Or to any row in the table? Im not totally sure what you're looking for.


Yes exactly - you would need to add another input...that's what my question was aiming towards.


So do you want the images to actually embedded in the worksheet? I don't know anything about the size of the photos you are looking to insert, but unless your photos are a few kb in size, I would caution against that, as your spreadsheet size will quickly become massive, even with a few hundred rows of data in the table. That means there's a few hundred photos in the spreadsheet. The links will open in your default photo viewer, but I think there's also some ways you could make a popup of some sort either through comments or a userform. I don't have recommendations for you as I've never done that sort of thing before. If this is a necessary feature, to be honest I think excel is not the best tool for the job.

ahhh, yeah that makes sense. so if i make a userform and just put it where i want the pic to load; it should be ok?

 

[severynm]

Kind of. There's probably a few different ways to do it, I would have a userform with an image control that references the desired image.