Automatic excel prompt to insert file name of picture when cell is clicked.

casyman

New Member
Joined
Jan 27, 2014
Messages
1
First time poster. I have an excel sheet with a bunch of drop down menus. It is designed so that when you select a choice in box 2A it narrows your choices in box 2B, which narrows your choice in box 2C. That is however not important. I have designed this for use on a tablet in the field. For each row we need a picture of what was observed in the field. Our requirements are to have a hyperlink to the picture live in a cell. Currently we are actually navigating to the file and copy/pasting the file name into excel. They are in the field on a tablet and this is very cumbersome. What am imagining is when that click on the cell, it will prompt them to navigate to the pictures fold and select a picture, which in turn copies the file name into the cell. Help if you can.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Forum statistics

Threads
1,223,897
Messages
6,175,269
Members
452,628
Latest member
dd2

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
Back
Top