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

48 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
  15. Excellent write-up. I absolutely appreciate this website. 토토

    ReplyDelete
  16. Thank you , this is really useful information towards my assessment. 경마

    ReplyDelete
  17. Thanks for sharing such great information. It was really helpful to me. 파친코사이트

    ReplyDelete
  18. Greetings! Very helpful advice in this particular post! It is the little changes that produce the biggest changes. Thanks a lot for sharing! 토토

    ReplyDelete
  19. I accidentally searched and visited your site. I still saw several posts during my visit, but the text was neat and readable. I will quote this post and post it on my blog. Would you like to visit my blog later? 토토사이트순위

    ReplyDelete
  20. Looking for Pay Someone To Take My Online Class? Yes, we’re the most trusted best online class help provider. We are pioneer of do my online Class for me.

    ReplyDelete
  21. Hard Rock Hotel & Casino Las Vegas
    The Hard 충청북도 출장안마 Rock 천안 출장안마 Hotel & Casino Las Vegas is the ultimate destination for gaming and entertainment, featuring more than 2600 electronic games, 경산 출장마사지 a 구미 출장안마 popular music 안양 출장마사지 venue,

    ReplyDelete
  22. Thanks for such a fantastic blog. Where else could anyone get that kind of info written in such a perfect way? I have a presentation that I am presently writhing on, and I have been on the look out for such great information. 메이저토토

    ReplyDelete
  23. I’m excited to uncover this page. I need to to thank you for ones time for this particularly fantastic read. 바둑이사이트넷

    ReplyDelete
  24. I will truly value the essayist's decision for picking this fantastic article fitting to my matter. 바카라사이트

    ReplyDelete
  25. I’m very pleased to discover this site. I want to to thank you for ones time for this particularly wonderful read!!
    토토사이트 , 바카라사이트 , 룰렛 , 토토사이트

    ReplyDelete
  26. Its an amazing website, really enjoy your articles. Helpful and interesting too. Keep doing this in future. I will support you. 바카라사이트

    ReplyDelete
  27. Actually Magnificent. I am also a specialist in this topic so I can understand your effort. 파칭코

    ReplyDelete
  28. We specialise providing eCommerce Websites, wordpress development houston & Magento Development, eCommerce Website Design, Local SEO Houston & Digital Marketing Houston Services.

    ReplyDelete
  29. What a post I've been looking for! I'm very happy to finally read this post. 토토사이트 Thank you very much. Can I refer to your post on my website? Your post touched me a lot and helped me a lot. If you have any questions, please visit my site and read what kind of posts I am posting. I am sure it will be interesting.

    ReplyDelete
  30. I no uncertainty esteeming each and every bit of it. It is an amazing site and superior to anything normal give. I need to grateful. Marvelous work! Every one of you complete an unfathomable blog, and have some extraordinary substance. Keep doing stunning 메이저사이트순위

    ReplyDelete
  31. Hey, I simply hopped over in your web page by means of StumbleUpon. Not one thing I might in most cases learn, however I favored your feelings none the less. Thank you for making something price reading. 메이저토토사이트

    ReplyDelete
  32. What a nice post! I'm so happy to read this. 토토사이트추천 What you wrote was very helpful to me. Thank you. Actually, I run a site similar to you. If you have time, could you visit my site? Please leave your comments after reading what I wrote. If you do so, I will actively reflect your opinion. I think it will be a great help to run my site. Have a good day.

    ReplyDelete
  33. I've been looking for photos and articles on this topic over the past few days due to a school assignment, casinosite and I'm really happy to find a post with the material I was looking for! I bookmark and will come often! Thanks :D

    ReplyDelete
  34. Hello, I am one of the most impressed people in your article. 토토사이트순위 I'm very curious about how you write such a good article. Are you an expert on this subject? I think so. Thank you again for allowing me to read these posts, and have a nice day today. Thank you.

    ReplyDelete

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