Thread: how can I make a ScrollBar &/or a SpinButton display values?
View Single Post
 
Old 12-29-2015, 10:15 AM
jeffk jeffk is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Jul 2012
Location: North of England, UK
Posts: 32
jeffk is on a distinguished road
Default how can I make a ScrollBar &/or a SpinButton display values?
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
Reply With Quote