Saturday, April 10, 2010

Add Spin Buttons Active X Excel

In my previous posts I have shared EMI Calculator with you. This was mode using Excel PMT function and Spin Buttons ActiveX Controls in Excel. In this post I am sharing how to add spin buttons ActiveX controls to excel worksheet.

Add Spin Buttons Active X Excel

Step 1 Have Developer Tab visible in your Excel 2007. In case you already have it proceed to step 2
Step 2 Click on Insert under controls group
Step 3 Click on Spin Buttons under ActiveX Controls
Step 4 Draw Spin Button on your worksheet.
Step 5 Rename the Spin Button Object
Step 6 Add VBA code to the Spin Button

Checkout Screen Cast Below
Add Spin Buttons Active X Excel


In this screen cast we have added spin button next to loan amount and renamed the spin button object as Loan
Similarly add two more spin buttons next to Interest Rate and Years. Rename them as Interest and Years respectively.

To make these buttons work we need to add VBA code. Separate macros are required for each button that is why we have renamed the spin buttons. It is to give them a name that can be related later on by us when we look at the macro code. Macro code will be using the names we have given to them

Now to add the VBA code , double click on the spin button object, it will open VBA editor. Copy following VBA code to worksheet module

Private Sub Loan_SpinDown()
    With Range("C4")
        .Value = WorksheetFunction.Max(100000, .Value - 100000)
    End With
End Sub

Private Sub Loan_SpinUp()
    With Range("C4")
        .Value = WorksheetFunction.Min(10000000, .Value + 100000)
    End With
End Sub

Private Sub Interest_SpinDown()
    With Range("C5")
        .Value = WorksheetFunction.Max(0.03, .Value - 0.0025)
    End With
End Sub

Private Sub Interest_SpinUp()
    With Range("C5")
        .Value = WorksheetFunction.Min(0.25, .Value + 0.0025)
    End With
End Sub
Private Sub Years_SpinDown()
    With Range("C6")
        .Value = WorksheetFunction.Max(1, .Value - 1)
    End With
End Sub

Private Sub Years_SpinUp()
    With Range("C6")
        .Value = WorksheetFunction.Min(25, .Value + 1)
    End With
End Sub


With this your EMI Calculator with Spin Buttons ActiveX Controls is ready

Visit EMI Calculator page if you want to download excel file complete with macros and Spin Buttons Activex controls

21 comments:

  1. Dear Yogesh brother,Your posts are really qualitative and very useful.I'm not able to change Spin button name as per above directions. Could you help me in resolve the issue.

    ReplyDelete
    Replies
    1. Machine Learning Projects for Final Year machine learning projects for final year

      Deep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.

      Python Training in Chennai Python Training in Chennai Angular Training Project Centers in Chennai

      Delete
  2. Permainan poker dengan modal Rp 10rb ialah satu modal awal untuk dapat lakukan investasi periode panjang
    asikqq
    dewaqq
    sumoqq
    interqq
    pionpoker
    bandar ceme terpercaya
    hobiqq
    paito warna
    forum prediksi

    ReplyDelete
  3. Shalom, Om swastiastu, Namo buddhaya, Salam kebajikan, pada artikel kali ini kami akan memberikan kepada kamu Panduan Cara Bet 2D Togel Klik4D Online yang tersedia di S128cash. Berhubung permainan togel adalah game legendaris di Indonesia, tahukah kamu kalau game togel sekarang bisa dimainkan secara online ? (Baca Selengkapnya Disini...)

    ReplyDelete
  4. Introducing Short-Duration Courses to Learn New Skills Online While India Is on a Nationwide Lockdown to Fight the Coronavirus Pandemic. Learn From Experts, Work on Live Projects, and Get Certified
    https://onlineidealab.com/short-courses/

    ReplyDelete
  5. Dissertation Services UK are accomplished and committed to aiding Ph.D. understudies. They may have dealt with a dissertation themselves before and like to help other people who are on a similar path today. Advisors are unassuming, buckle down, and have fantastic relational abilities.

    ReplyDelete
  6. Thanks for giving best examples and also for a creative content
    Visit Tech Linkz

    ReplyDelete
  7. I feel that it is best to write more on this matter, it may not be a taboo topic however usually individuals are not enough to talk on such topics. 바카라사이트

    ReplyDelete
  8. In my past posts I have imparted EMI Calculator to you. This was mode utilizingAssignment Writing Service Uk Excel PMT capacity and Spin Buttons ActiveX Controls in Excel. In this post I am sharing how to add turn buttons ActiveX controls to dominate worksheet.

    ReplyDelete
  9. Rammafoundation is a foundation and company that can repair damage of guttersConcrete foundation repair edmonton.we provides best services for our custumers in alberta (canada)

    ReplyDelete
  10. searching for such an informative post since many days and it seems my search jst ended here.Good work.Keep posting. 스포츠토토

    ReplyDelete
  11. We leave no stone unturned to make sure our clients receive what they have been promised. You can contact us at Buy Assignment Uk - Assignmentdone.co.uk . We even offer free revisions at if the client is not happy.

    ReplyDelete
  12. I didn't know about this its so helpful. Thanks for sharing this. Pay Someone To Take Online Course

    ReplyDelete
  13. Do you have a spam problem on this blog; I also am a blogger, and I was wanting to know your situation; many of us have created some nice practices and we are looking to exchange solutions with other folks, be sure to shoot me an e-mail if interested.

    무료야설
    오피
    외국인출장
    마사지
    카지노사이트

    ReplyDelete
  14. I've been looking for such a useful content for a long time and it appears that my hunt has finally come to an end here. You did an excellent job. Continue to post.
    Like so many families, when we suffered the loss of my mother last year we faced the difficult decision of what to do next.
    Funeral Directors Falkirk

    ReplyDelete

Learn how to create Excel dashboards.
Yogesh Gupta's Excel Tips