1

I have got 23 cells in my worksheet, where I would like to put the button with next & previous.

I have already the macro code and the button prepared.

enter image description here

But it looks like it refers only to the 1st sheet.

enter image description here

I cannot copy and paste this spin button as I did in case of form control buttons.

I found some links here:

https://www.excel-easy.com/vba/examples/spin-button.html

Launch a different sheet by Spin button

But they don't help me

Is there some way to speed up this?

Plutian
  • 2,276
  • 3
  • 14
  • 23
Geographos
  • 827
  • 2
  • 23
  • 57
  • Any reason you can't just copy and paste this spin button? You'd need to copy and paste the code for them to each sheet as well, but I don't see why that wouldn't work. – Plutian Dec 04 '19 at 11:41
  • I already firued out how to copy button, although the code must be still inputted manually (at least copied) sheet by sheet. – Geographos Dec 04 '19 at 11:44
  • Yes, this is how it is I'm afraid, by design the code for an ActiveX control is located on the sheet it's on. However [there is a way to add code dynamically](https://stackoverflow.com/questions/41612140/automatically-add-option-private-module-to-all-modules-in-vba) but I suppose that solution could take much longer than just manually copy-pasting your code to your sheets. – Plutian Dec 04 '19 at 11:50

0 Answers0