Excel Camera Tool Automated Placement

R

Randy

I'm dashboarding with Excel and have everything finished except for
programmatic placement of camera objects. Here's the gist:



My dashboard selects an image to copy with the camera tool based on the
results of various lookup and choose functions applied to data pulled from an
ODBC query embedded in a worksheet. The Camera object is placed on a display
worksheet so that the dashboard is nothing more than a worksheet with a
collection of camera objects referencing various data and images from other
hidden worksheets.



My question is: how do I automagically determine the display position of the
camera object based on data in another worksheet? For instance, if Sheet3!A1
equals C14, then I want a particular camera image to show up at Sheet1!C14.
The idea is kind of like an autogenerated map - if the data says a "red
truck" is in "texas", then I want a camera object pointing at "red truck" to
pop up in the location "texas".



I have everything working except that the resultant image has to be manually
placed - how do I do this programmatically? Please note that everything I
know about programming came from the back of a Wheaties box.



Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top