Set Refresh Time on cell value

**adam2308** · 07-18-2009, 04:20 PM

I googled how to auto-refresh a web query (i did search the forum but couldn't find anything

) quicker than the minimum one minute that excel seems to let you set it to and i found the following code...

Please Login or Register  to view this content.

I have done the above but what i want to ask is can i alter the time value as highlighted at the bottom of the code by a given cell value. Probably an easy one this but i am a bit of a numpty!!

Just to clarify it's the seconds of the time value i want change.

Thanks,
Adam.

**Mallycat** · 07-18-2009, 08:45 PM

There is no reason why you can't put the time in a cell. I would suggest using numbers, not dates/times in your sheet, as they are easier to work with.

the following will work if you want time

Just substitute this line

RunWhen = Now + TimeValue("00:00:30")

with this line

RunWhen = Now + Range("a1")

and where you have a time in the format 00:00:00 in cell A1.

I think this will work