Help popup window if condition is TRUE in change event if conditon is true

Here is the code. Right click on the Sheet1 tab, click 'View Code' and paste it there:

Please Login or Register  to view this content.

Here is the workbook with the code already there. Book1.xlsm

I'm sorry, I have never tried to add audio files to a worksheet in VBA. You would have to provide me with a audio file and tell me exactly where it is going to be saved on your computer if you wanted me to try that though.

I'm also not sure what this means:

design one message box using form and show if condition is true...etc...

thanks once again for prompt reply.

I have noticed following.

1. Whenever condition is False then also message window appear.
2. if i type anywhere in sheet then also message window appear.

Pls note ...i will connect this sheet with live market with RTD function so current rate will keep changing automatically.

so message window appear only if condition is true. in your code even condition is False message window is appearing.

pls help...

You will have to give me the condition you want for each line then. Your original post said if it to goes above the trigger show a popup to buy + the remark for that line, and if it goes below the trigger show a popup to sell + the remark for that line. You need to tell me the condition you want for each line if you want each line to have unique criteria.

thanks brother...

Lets be friends i m from india.

i will draft nice excel file which will explain conditions.
my email id is kodaksecurities @ gmail

pls add me ..we will chat in details..

as per instruction added file with criteria.

Pls help

would be great help, If you address my query...