L
Legacy 76526
Guest
Hi All,
I have searched the boards (message box, dynamic data, stock market, dialog boxes) and internet but have not found out how I can solve my problem.
I have an excel spreadsheet (Excel 2002) using Windows XP home and the spreadsheet has DDE links to import dynamic data from the stock exchange. The spreadsheet works fine except for the ability to alert me to possible and immediate buy opportunities. Currently I have a colour change to signal these opportunities, but would prefer a message box popping up instead to make more efficient use of my time.
When the buy condition is met, I would like a message box, preferably in a new window which I can minimise to the taskbar, to tell me which stock code (eg XYZ) has reached the condition. If it also pops up with a simple "boing" sound, then this is a bonus. I would like a simple 'OK' button to close the window.
I have 200 stock codes in excel in column A2 to A201, with my target buy price for each stock correspondingly in column J and the Asking price (dynamic) for each correspondingly in column H.
Because of the use of dynamic data, the message box must not fire perpetually once the true condition is met. In an attempt to get around this problem I have been thinking of using a drop down menu in column T with choice of "" (blank) or "fired" ("fired" is stored in cell $v$4). Thus when the buy condition is met, the program MUST also check if column T cell is blank; if it is then it fires the pop up box and THEN changes T cell to say "fired" (ie copies cell $v$4) to prevent perpetual firing. I hope thats possible! If the buy condition is no longer valid (ie the price drops in value) I want to manually change the value of T cell back to blank (which is currently what i do now)
Here is a summary of my desired features:
1. It will display the stock code of the company (recalling column A value)
2. It will not override other message boxes already displayed (ie a separate box for each message)
3. It will not perpetually fire whilst the true condition is met.
4. Excel will be using dynamically changing data and thus the macro must be able to tolerate DDE links.
5. It will have a simple ‘OK’ button that will make the message box disappear.
6. Firing with a sound is desirable, but not critical.
7. Message box to be in its own window and must be minimisable to the taskbar.
8. Message boxes are dynamic, thus do not need to queue for fired one to be attended to before firing the next.
I have a book on VBA macros and can struggle with understanding the coding language but it takes me a bit of time. I am no idiot with Excel but have had nil to do with writing macros or VBA.
Would appreciate full coding.
I have searched the boards (message box, dynamic data, stock market, dialog boxes) and internet but have not found out how I can solve my problem.
I have an excel spreadsheet (Excel 2002) using Windows XP home and the spreadsheet has DDE links to import dynamic data from the stock exchange. The spreadsheet works fine except for the ability to alert me to possible and immediate buy opportunities. Currently I have a colour change to signal these opportunities, but would prefer a message box popping up instead to make more efficient use of my time.
When the buy condition is met, I would like a message box, preferably in a new window which I can minimise to the taskbar, to tell me which stock code (eg XYZ) has reached the condition. If it also pops up with a simple "boing" sound, then this is a bonus. I would like a simple 'OK' button to close the window.
I have 200 stock codes in excel in column A2 to A201, with my target buy price for each stock correspondingly in column J and the Asking price (dynamic) for each correspondingly in column H.
Because of the use of dynamic data, the message box must not fire perpetually once the true condition is met. In an attempt to get around this problem I have been thinking of using a drop down menu in column T with choice of "" (blank) or "fired" ("fired" is stored in cell $v$4). Thus when the buy condition is met, the program MUST also check if column T cell is blank; if it is then it fires the pop up box and THEN changes T cell to say "fired" (ie copies cell $v$4) to prevent perpetual firing. I hope thats possible! If the buy condition is no longer valid (ie the price drops in value) I want to manually change the value of T cell back to blank (which is currently what i do now)
Here is a summary of my desired features:
1. It will display the stock code of the company (recalling column A value)
2. It will not override other message boxes already displayed (ie a separate box for each message)
3. It will not perpetually fire whilst the true condition is met.
4. Excel will be using dynamically changing data and thus the macro must be able to tolerate DDE links.
5. It will have a simple ‘OK’ button that will make the message box disappear.
6. Firing with a sound is desirable, but not critical.
7. Message box to be in its own window and must be minimisable to the taskbar.
8. Message boxes are dynamic, thus do not need to queue for fired one to be attended to before firing the next.
I have a book on VBA macros and can struggle with understanding the coding language but it takes me a bit of time. I am no idiot with Excel but have had nil to do with writing macros or VBA.
Would appreciate full coding.