ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spinner Button - Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/58262-spinner-button-excel-2000-a.html)

KenSBrantford

Spinner Button - Excel 2000
 
I'd like to creat a basic spinner button that returns a value betteen 0 and
$3M. When I right click on the spinner button after adding it to the
worksheet and select format control, I don't see a tab for "control"

Please assist in how to add/create this basic spinner button.

Thanks

Dave Peterson

Spinner Button - Excel 2000
 
There's a spinner on the Forms toolbar and a spinner on the control toolbox
toolbar.

The forms toolbar version has that tab under the rightclick.

You can rightclick on the spinner from the control toolbox toolbar and choose
properties to get to lots of, er, properties.



KenSBrantford wrote:

I'd like to creat a basic spinner button that returns a value betteen 0 and
$3M. When I right click on the spinner button after adding it to the
worksheet and select format control, I don't see a tab for "control"

Please assist in how to add/create this basic spinner button.

Thanks


--

Dave Peterson


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com