"Nag Screen" pop up
 

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

"Nag Screen" pop up
 

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

"Nag Screen" pop up
 

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

"Nag Screen" pop up
 

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

"Nag Screen" pop up
 

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