Spin Button and Worksheet_change event
 

A spin button's Linkedcell property is set to G2. In the onchange
event for the worksheet a certain bit of code is supposed to fire but
doesn't wheen the spin button is clicked. The code run when the value
is manually entered in the cell. Is this the way its supposed to work
and is there a way around this?
Dk

Spin Button and Worksheet_change event
 

You have probably put the code in a module instead of the worksheet cod
module (??). Right click the tab & "View Code" or Double click the spi
button to get to the right place

--
Message posted from http://www.ExcelForum.com