Convert Numbers into Words

Read complete tip

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.

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

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

49 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.

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

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

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...)

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/

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.

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

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. 바카라사이트

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.

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)

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

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.

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

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.

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

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

15. Excellent write-up. I absolutely appreciate this website. 토토

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

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

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

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? 토토사이트순위

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.

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,

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. 메이저토토

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

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

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

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

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

28. 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.

29. 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 메이저사이트순위

30. I used to be suggested this website by means of my cousin. I’m now not sure whether
this submit is written by him as nobody else know such detailed approximately my problem.
ragdoll kitten for sale
ragdoll kittens for sale
mini goldendoodle for sale
mini bernedoodle puppies for sale
mini aussiedoodles for sale
havanese puppy for sale
teacup havanese puppies for sale
havanese puppies for sale near me
havanese puppies for sale under \$1,000
havanese puppy for sale

https://thegorgeousragdolls.com/

31. Ahaa, its nice dialogue about this piece of writing at this place at this webpage,
I have read all that, so at this time me also commenting here.
havanese dogs for sale
havanese puppies for sale
teacup havanese puppy
chocolate havanese puppy for sale
teacup pomeranian for sale
doodle puppies
aussiedoodle puppies for sale
bernedoodle puppies for sale
goldendoodle puppies for sale
yorkie puppies for sale

https://www.fluffyhavanese.com/

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.

33. This comment has been removed by the author.

34. Thankyou so much for this amazing Blog.
If you want a durable and dependable roof. particularly if it will endure for a long period. Lead sheet roofing in Greenock would be ideal for you. Installing new lead sheets is a task that our knowledgeable staff excels at. In addition, our lead sheet maintenance technique is quite effective.

35. If you are looking for Roofer in Wallingford NJB roofing and Son LTD Would Be Your First Choice

36. Bottle In A Box are the UK’s top supplier of alcohol gift sets. gin hamper

37. This will help me a lot. Because I have a lot of work to do with spin button and after using this methods it will be in front of me. Thanks for sharing this with us. I really appreciate that. Now it's time to avail vacuum storage bags for more information.