How Can I Most Elegantly Reveal A Picture That Proportionally Reveals Itself Each Hour Until A Certain Time Is Reached?

[ultam8]

Good Morning,

I am interested in using excel to set a date/time, say for retirement, and then embed a photograph of a beach, and then based off of "now" and the set date/time have the photo reveal itself (maybe like the hands of a clock move?) each hour as time progresses towards the set date/time.

I saw this years ago and have scoured search engines to try and find it, and the closes I found was this: How to Make a Calendar in Excel that Reveals a Picture - Tutorial which is interesting if your time-frame is just one month, but mine is much longer and instead of revealing as the days of a calendar, I hope to revel this photo similar to how clock hands move, starting a 12. I welcome any suggestions and thanks for considering.

 

[Micron]

How about setting the picture mode to clip and using code like this (to change the image control height):

VBA Macro On Timer style to run code every set number of seconds, i.e. 120 seconds

I have a need to run a piece of code every 120 seconds. I am looking for an easy way to do this in VBA. I know that it would be possible to get the timer value from the Auto_Open event to prevent

stackoverflow.com

I imagine the last time value used will have to be stored and retrieved from a cell.

 

[ultam8]

OK, you'll have to excuse my novice-ness...can you give me a link to somewhere explaining "setting the picture mode to clip" in the context that we are talking about (in which it will relate to the "now time, and clip as a proportion of some set start time and some set end time such that stat is about 1% of picture showing, and end is 100%?), please? and then the link in you rpost is to what till run it periodically so I don't have refresh?

Thank you and I hope I got that right...

 

[Micron]

Picture mode is a property of an image control, which I somehow got the notion that you intended to use one, or the link did. Seems now that it was neither. However, I have no idea how you'd uncover an image as if the sweep of clock hands was revealing more an more of it as the days pass. I guess the only hope would be a picture for each day remaining, each one with more revealed. You'd need a way to 'map' a particular image to a particular day. My idea was just to expose a bit more of one image each day by making the image control taller for each. Clip is the setting that doesn't resize the image to fit the control, so that could work.

Info on the control as it applies to Excel

Add an image control to a worksheet - Microsoft Support

Add an image control to a worksheet. You can add a Form control or an ActiveX control and set properties for both.

support.microsoft.com