Need help creating a pop-up alert that can host a dynamic list

[psulion01]

Sorry if the subject is a bit confusing... Here's what I'm trying to do.

I'd building a stock price alert sheet, much like many others have done on this board. Basically there will be thresholds/triggers, live market data being fed in, and some sort of marker column to indicate when an alert has been triggered (and should be sent to pop-up) and when it has been reset by the user.

The pop-up I'm looking to create (dialog box or userform of some type) should have the following characteristics:

1) Hopefully it won't disable the data feed/auto calcs/other scripts running on my sheet (i.e. if the user doesn't click 'OK' then nothing else in Excel can happen -- this would be a problem)

2) The pop-up is persistent enough that it isn't overlooked by the user, i.e. Always on Top, flashing Excel bar in taskbar, etc. Something to that effect...

3) The pop-up will ideally look more like a list or log, able to house multiple alerts at once. For example, if one alert pops up and the user is away from their desk, and then a second alert appears, I'd like for both to be listed in the alert window. Is something like this even possible? Can I embed part of a worksheet into something like a userform, so that as cells of the sheet are populated they appear in the "pop-up"? If not, I would need the ability to have multiple pop-ups at once (for different alerts being triggered simultaneously or before the previous alert was dismissed).


Hopefully that's a start... I'm fairly comfortable with VBA but can't do much from scratch. I feel like I can figure out how to structure my sheet, autocalc code, markers, etc, but the pop-up is causing some trouble. Any help would be appreciated.


Thanks!

 

[psulion01]

Sorry... to clarify, I think what I'm looking for is a popup box similar to the reminder box that Outlook uses for calendar reminders. As multiple reminders queue up they can all be displayed in the one popular with the ability to dismiss one/some/all. Does that help?


Thanks again!

 

[tweedle]

I'm thinking you start with a User Form with a ListBox and a Button.

Whenever it's time to start displaying the form

Load UserForm1
UserForm1.Show False
UserForm1.ListBox1.AddItem "ALERTS"

As events occur that you want to Alert,

keep calling

UserForm1.ListBox1.AddItem "your text here"

Eventually, you want to allow removal of the Alert
So if the user selects an alert in the UserForm, and clicks the button
then that item is deleted from the list
(Could also be logged to a sheet that so-n-so cleared {this alert} at this date/time ), something like that.


If you REALLY want it like Outlook, you can actually use Outlook and add Reminders to it.

 

[psulion01]

I'm thinking you start with a User Form with a ListBox and a Button.

Whenever it's time to start displaying the form

Load UserForm1
UserForm1.Show False
UserForm1.ListBox1.AddItem "ALERTS"

As events occur that you want to Alert,

keep calling

UserForm1.ListBox1.AddItem "your text here"

Eventually, you want to allow removal of the Alert
So if the user selects an alert in the UserForm, and clicks the button
then that item is deleted from the list
(Could also be logged to a sheet that so-n-so cleared {this alert} at this date/time ), something like that.


If you REALLY want it like Outlook, you can actually use Outlook and add Reminders to it.

This sounds about right...thanks. I played with some code that creates Outlook Tasks with reminders but was having problems getting alerts to queue up properly. It seemed like the code was just overwriting the first alert, rather than creating all of them. I had coded a simple loop to try and generate 5 tasks in a row but wasn't having much luck. I can post that code later (it's on my work computer), but would like to experiment with your code above first.

Just curious, but is any of the data in the ListBox being stored on a sheet somewhere, or just in the listbox? Also, can you point me in the right direction regarding the code for the button to remove the alert from the listbox (and perhaps log it on a sheet)?

Also just thinking ahead here, but do you think I'd need some type of controls on my alert/tracking sheet to record a timestamp and trigger marker that is updated when the alert is met? Just trying to think how the sheet will know which alerts are new and should be added to the listbox. Just wondering if two alerts triggering at the same time would present problems. Perhaps the sheet running a loop to check for new alerts (say every 2 mins) with a timestamp would help identify which alerts are "new" since the last loop.

Thanks for the reply...at least I have somewhere to start right now!