{"id":12110,"date":"2011-12-17T20:06:36","date_gmt":"2011-12-17T20:06:36","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1076"},"modified":"2011-12-17T20:06:36","modified_gmt":"2011-12-17T20:06:36","slug":"use-of-spin-button-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/12\/use-of-spin-button-in-excel\/","title":{"rendered":"Excel Macro Tutorial : VBA Spin Button"},"content":{"rendered":"
In the previous Article How to write Excel Macro – Your First Excel Macro<\/a><\/strong> of <\/a>Excel Macro Tutorial<\/strong>, you have seen how to write Excel Macro. Also in Previous Tutorials, you have seen all the basic concept of Excel Macro. In this Article I am going to show you how to Add and Use Spin Button. Step 1.<\/strong>Go to Developer’s Tab (How to Add Developer’s Add in to the Ribbon<\/a>)
\n<\/p>\n
\n
\nSpin Button:<\/strong> Spin button is an ActiveX Control which have Two Buttons Up and Down. Both the buttons always remain together but function separately. Generally you might have seen this button in many dialog box where user wants to increase or decrease values in a Text box or anywhere by clicking on Up or Down button correspondingly.
\n
\n<\/a>
\n<\/p>\nHow to Add VBA Spin Button in your Excel Sheet<\/h3>\n
\nStep 2.<\/strong>Go to to Controls Section -> Click on Arrow on INSERT button
\nStep 3.<\/strong>Click on ActiveX Spin Button
\nStep 4.<\/strong>Now Drag the Place where you want to Place that button and re-size as per your requirement.<\/strong><\/strong><\/strong>
\n
\n