RE: Multiple display of timed userforms ...

chazrab

Well-known Member
Joined
Oct 21, 2006
Messages
881
Office Version
  1. 365
Platform
  1. Windows
RE: Multiple display of timed userforms ...

Action1: it's 8:00 AM. Open a new Userform1(blank textbox1):
Enter data:
Code:
Userform.DTPicker1.value  = Time 10:00 AM (display time)
Userform1.Textbox1.value  = Buy oranges
close userform

Action2: 5 minutes later: open a new Userform1(blank textbox1)
Enter data:
Code:
DTPicker1 = Time 11:00 AM (display time)
Textbox1 = Buy apples
close userform

Desired result:
Code:
Two instances of Userform1 display  side by side at  11:00 AM, 
the earlier userform1 and the later userform1  showing
Userform1 . Textbox1.value = Buy oranges
Userform1. Textbox1.Value = Buy apples

How would I get two instances of a userform with different display set times and entered textbox values to display simultaneously(.Top and .Left to be adjusted to view both? Showmodal = false on both to allow interaction with textboxes



Is there any way this can be done, even with duplicate userforms ?
I would appreciate any help anyone can give me on this.

Thx
cr
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,214,518
Messages
6,119,985
Members
448,935
Latest member
ijat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top