VBA Help with Inventory manager (without a userform)

BRUNO21

New Member
Joined
Mar 23, 2021
Messages
7
Office Version
  1. 2016
Platform
  1. Windows
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.
pic 1.png
 

Attachments

  • pic2.jpg
    pic2.jpg
    75.5 KB · Views: 12

BRUNO21

New Member
Joined
Mar 23, 2021
Messages
7
Office Version
  1. 2016
Platform
  1. Windows
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?
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

severynm

Board Regular
Joined
Jan 8, 2021
Messages
64
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,045
Messages
5,639,750
Members
417,108
Latest member
Thein Than

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top