I created Userform1 with a simple Textbox1 that allows users to enter any text.
Listbox1's Rowsource would be just a range in col A of Sheet1 with Times such as 5:30 AM in 30 min. increments over a 24 hr period(24 rows in drop down list).
DTPicker1 would allow a user to enter a future date, say DTPIcker1 = 01/27/2017 and a time, say, Listbox1.value = 10:00 AM.
The user types some text, clicks an OK button on the Form that unloads it.
When 10:00 AM on 01/27/2017 arrives, the Userform pops up with the previously entered text in Textbox1. This can be then postponed, deleted and changed to suit needs. To anyone's knowledge, has this been done?
If not, how would you use the Listbox Time in combination with the DTPicker to set the Userform to display at the specified future day and time. ?
Application.wait just SUSPENDS not CLOSES the form, so I don't think it would work here.
To me, code has to open the form every day from a button on the sheet, search for the date and time on Sheet1 when the form opens and compare it to Now().
I turn my laptop off every night and turn it back on in the morning. Correct code would have to account for this. Is there a simple way to do all this without a huge code block?
Can anyone help me with this ?
Thans for anyone's help.
cr
Listbox1's Rowsource would be just a range in col A of Sheet1 with Times such as 5:30 AM in 30 min. increments over a 24 hr period(24 rows in drop down list).
DTPicker1 would allow a user to enter a future date, say DTPIcker1 = 01/27/2017 and a time, say, Listbox1.value = 10:00 AM.
The user types some text, clicks an OK button on the Form that unloads it.
When 10:00 AM on 01/27/2017 arrives, the Userform pops up with the previously entered text in Textbox1. This can be then postponed, deleted and changed to suit needs. To anyone's knowledge, has this been done?
If not, how would you use the Listbox Time in combination with the DTPicker to set the Userform to display at the specified future day and time. ?
Application.wait just SUSPENDS not CLOSES the form, so I don't think it would work here.
To me, code has to open the form every day from a button on the sheet, search for the date and time on Sheet1 when the form opens and compare it to Now().
I turn my laptop off every night and turn it back on in the morning. Correct code would have to account for this. Is there a simple way to do all this without a huge code block?
Can anyone help me with this ?
Thans for anyone's help.
cr
