RE: Multiple display of timed userforms ...

chazrab

Well-known Member
Joined
Oct 21, 2006
Messages
882
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

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,214,614
Messages
6,120,525
Members
448,969
Latest member
mirek8991

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