RE: Multiple display of timed userforms ...

chazrab

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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

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