Code for Prompt

[ecuevas]

Is there any code that I can write in an excel spreadsheet that will prompt the user to enter a picture instead of text?

 

[Moniker]

Yes, it's called VBA. Are you familiar with VBA at all? There's nothing built-in to Excel to do that, but there are plenty of programmatic ways to do it.

 

[ecuevas]

I have never used VBA. Some of the people I work with do have some experience with it but the aren't sure exactly what to type in. Do you know what code I can input to make it do what I need it to do?

 

[Moniker]

I can write it, sure, but that's the "give a fish/teach to fish" analogy. Assuming you're wanting a person to reach a certain cell in Excel, you would write a program that waits for the user to navigate to or click on that cell, and then you'd fire the code that launches a dialog box asking them for the picture.

You're not telling me if you're just in a spreadsheet, a form in Excel (easier, actually, in this case), a specific worksheet, or something else. Also, you've not mentioned what this picture is for. It almost sounds like you're trying to write a database application in Excel. While that's technically possible, it's a giant pain in the ass for anything beyond simple lookups.

 

[ecuevas]

Can't you just tell me how to do it. I need this by tomorow an I don't have time to figure it out. I am trying to do this in a form but I guess it doesn't have to be in excel. My boss needs it so that the warehouse people can paste pictures into the form and send it to him.

 

[Moniker]

In the future, please don't over-promise what you don't know how to do.

See the example for how to do this in Excel. It shows you how to import a picture into Excel by pressing a command button.

 

[ecuevas]

THANK YOU!!! That is exactly what we were trying to do.

 

[ecuevas]

Do you know how to delete the picture so that the box is empty agin?