Check out our other answers here • Wise Owl Answers
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Download finished file here www.wiseowl.co.uk/vba-macros/...
This video explains how to use a single ActiveX spin button control in Excel to control different cells in a worksheet. You'll learn how to set properties of a spin button control using the Properties window and using VBA code. You'll also learn how to use the Worksheet Selection Change event to trigger code when a user clicks on a cell. Finally, you'll see how to use some basic If statements to check if a cell value is number and if the number falls within a range.
Chapters
00:00 The Question
00:29 Creating a Spin Button
02:37 Using the Worksheet Selection Change Event
05:14 Using the Intersect Method
07:03 Detaching the Spin Button from a Cell
07:47 Highlighting the Last Valid Selection
09:47 Checking if a Cell Contains a Number
11:27 Checking a Number is Within a Range
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Негізгі бет Wise Owl Answers - How Do I Control Different Cells with One Spin Button in Excel VBA?
Пікірлер: 64