Message to pop up on another computer

[minette]

Hi all, I couldn't find the exact answer to my question, so I thought I'd post a new thread.

I have a spreadsheet, which needs to send a LAN-type alert to another computer when a value of over 100k is entered in a certain column. The alert/message/pop-up needs to have all the information from the current row in it. E.g. name, surname, company and amount. Also which user has just input the information. So the message to be displayed on the other computer might say something like: "Alice Woods, has just entered the amount of £100,000 for Mr. A Smith, from ABC Inc". It needs to be an immediate message, so cannot go via email, as it sometimes takes up to 5mins or so to be delivered - sometimes even longer.

Obviously needs to be done using VBA, but I don't have any idea where to start.

Any brave souls out there who might be able to help me, please?

Thanks so much for looking....
Minette

 

[bendo93]

was this ever resolved ? can you send popup messages to other users using vba ?

hi, i'm currently having the same project, i need to send a pop up on all the computers of my network, but without using cmd. i was thinking of using vba but could someone help me pls