"Nag Screen" pop up

[Roger on Excel]

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

 

[Barb Reinhardt]

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?

 

[Roger on Excel]

Hi Barb,

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

Yes, what you describe sounds perfect.

Roger

 

[Greg Glynn]

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

 

[Jon Peltier]

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