Private Sub - Change Event

[cabroncito29]

I have created a macro that gets information from a userform and creates a new ActiveX slider on the worksheet. The last step I would want it to do is add the Private Sub required for when the slider is moved. Is it possible to have my routine that adds the slider to create the Private Sub?

[Kyle123]

Generally it's not a good idea to use ActiveX controls on worksheets.

Why not just use a forms control slider on the worksheet? That way you can assign a macro to its .action property