Spinner VBA

[silkpantsman]

Im trying to use a spinner to change cell value this change in value initiates VBA then conditional operator 'IF' based on the cell in question. Code works fine when value is entered into cell but not when spinner changes value of the cell. Any ideas?

Please Login or Register  to view this content.

[StuCram]

Here's the approach I would use..

a) Make a subprogram that does the same actions.
b) Change the above Sub to call that subprogram, perhaps after verifying the target.
c) Assign the same macro to the spinner control (right-click on it, …)

That's about it.
- Stu