Macro after Spin Button operated

Hi .. I have a sheet that will be a control surface to send Telnet control texts...The page is a mass of spin buttons (arrow up/down) and I want a macro to run, add the new value to the telnet list and then send the command.

My problem is that the spinbutton up/down arrows may be clicked several times as the adjustment is made and I don't want dozens of commands sent and clog up the system

Is there any way to look at the last click value only ?
There are a mass of these buttons on the sheet so I don't want the delay to be very long....maybe a max of 1 second...and would prefer not to need a "update" button.

Thanks in advance

Andrew

you can make a module level flag that disables spin execution until things are done.

Please Login or Register  to view this content.

Hi there ...thank you for the reply ....I must be doing something wrong because it doesn't seem to do anything