I would like a nag screen to pop up after a certain amount of time in my
proprietary spreadsheet.

I would like to include a nag screen to remind users to renew their license
after a trial period.

Ive heard of the ontime method, but ive ford C. Pearsons site unhelpful /
overly complicated

Can anyone help?

Thanks,

Roger

YOu may want to save the date the first time this user opens the spreadsheet
in a named range. Then every time it's opened, check the time delta and put
a message box up if the delta is greater than some predetermined time.

Is that what you had in mind?
--
HTH,
Barb Reinhardt



"Roger on Excel" wrote:

I would like a nag screen to pop up after a certain amount of time in my
proprietary spreadsheet.

I would like to include a nag screen to remind users to renew their license
after a trial period.

Ive heard of the ontime method, but ive ford C. Pearsons site unhelpful /
overly complicated

Can anyone help?

Thanks,

Roger

Hi Barb,

Hope you are well. Thanks for getting back to me again.

Yes, what you describe sounds perfect.

Roger



"Barb Reinhardt" wrote:

YOu may want to save the date the first time this user opens the spreadsheet
in a named range. Then every time it's opened, check the time delta and put
a message box up if the delta is greater than some predetermined time.

Is that what you had in mind?
--
HTH,
Barb Reinhardt



"Roger on Excel" wrote:

I would like a nag screen to pop up after a certain amount of time in my
proprietary spreadsheet.

I would like to include a nag screen to remind users to renew their license
after a trial period.

Ive heard of the ontime method, but ive ford C. Pearsons site unhelpful /
overly complicated

Can anyone help?

Thanks,

Roger

I find it hard to believe that Chip Pearson's website was not
useful ... The man's a certified genius.

Anyhoo ... Pop a MODELESS form up and loop for 6 seconds like this:

For x = 6 To 0 Step -1
WaitTime = Now + TimeValue("0:00:01")
Next x

I think the OP wanted the form to appear at regular intervals, like once a
week or once a month. Anything using OnTime or Wait will not be practical
for that kind of delay.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Greg Glynn" wrote in message
...
I find it hard to believe that Chip Pearson's website was not
useful ... The man's a certified genius.

Anyhoo ... Pop a MODELESS form up and loop for 6 seconds like this:

For x = 6 To 0 Step -1
WaitTime = Now + TimeValue("0:00:01")
Next x