how can I make a ScrollBar &/or a SpinButton display values?

jeffk · #1 12-29-2015, 10:15 AM

I'm creating a UserForm in Excel 2007 & I want users to be able to Scroll/Spin to the value they want but neither of the ScrollBar or SpinButton display any values?

I know if I create a 'standalone' ScrollBar or SpinButton on a worksheet (developer tab > controls group > insert) I can link it to a cell so the result shows...........how can I get an equivalent affect in a UserForm?

Thanks

Debaser · #2 12-30-2015, 03:10 AM

You need to use another control, such as a TextBox or Label, and update that using the Scrollbar or Spinbar.

jeffk · #3 01-01-2016, 07:10 AM

Quote:

Originally Posted by Debaser

You need to use another control, such as a TextBox or Label, and update that using the Scrollbar or Spinbar.

Thanks, I thought it'd would be something like that......any clues about how do it?

Debaser · #4 01-04-2016, 04:25 AM

Assuming default names for a Spinbutton and Label control, you would have:

Code:

Private Sub SpinButton1_Change()
    Me.Label1.Caption = Me.SpinButton1.Value
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display multiple values as new values based on selection from template.	MvdB	Excel	2	09-29-2015 08:51 PM
Need to display values with the most votes first	PatW	Excel	1	02-12-2015 09:22 AM
How to Display Summary Values using Group filter in Task Usage	Glenn Faulkner	Project	5	03-31-2014 01:14 PM
Help with incrementing Spinbutton value.	dlowrey	Excel Programming	3	11-24-2013 12:28 PM
Display unique values and count the number of child items	vthomeschoolmom	Excel	2	07-25-2013 06:17 AM