Spin Button Control - Incremental Change

VBA_Newbie

Active Member
Joined
Jan 7, 2005
Messages
258
Hi folks,

Quick question - I've added spin button control into a worksheet and linked it to a cell. I'm using it to input a price (which later will be used for price elasticity simulations). However, it only allows me to have increments of $1 ($1.00, $2.00...) I need it increase/decrease by the penny ($1.98, $1.99....). Is there a way to do this?

Many thanks in advance!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening VBA_Newbie

It depends on what type of control you're using. If you're using the control from the Forms toolbar, then no. You would have more control from the control in the ControlToolbox toolbar.

However, the cell the user sees increment needn't be the actual cell that is linked to the control. If the linked cell is, say, Z1 out of the users field of view, cell A1 could have a fomula =Z1/100. The user would see the cell incrementing by $0.01 at a time.

HTH

DominicB
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
Mike

You can't specify a decimal increment for any spin button.

What you would need to do would use some sort of workaround where you divide by 100, something like Domenic has suggested perhaps.
 

Forum statistics

Threads
1,137,294
Messages
5,680,654
Members
419,923
Latest member
Kalthus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top