Help with spin button

**miko.sims** · 10-08-2013, 05:56 PM

Hey again, I was wondering if anyone could help with a spin button programming.
I am looking to change 2 fields on an excel sheet - C21 and C22- with a spiin button(up and down)
I did some research and found the code below which works but when i click anywhere on the screen i can change the value, i am looking to have 1 spin button change C21 when i am clicked on it and when I click on C22 i can change the number of it(up or down)
the code below works, but i can click anybox on the excel sheet and change the number which is not acceptable. Does anyone know how to do this.

any help is appreciated.

-------------------------------------

Please Login or Register  to view this content.

--------------------------------------------------------------

**miko.sims** · 10-08-2013, 07:29 PM

no one? anyone?

**GraemeG** · 10-09-2013, 01:05 AM

I don't really understand the question, sorry.
The default Spinner buttons that come with Excel don't satisfy your needs somehow?
What you seem to be wanting is exactly what they do, surely?
GG

**protonLeah** · 10-09-2013, 01:06 AM

To attach a Workbook
(please do not post pictures of worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"