Use Excel VBA to Create Spin Buttons - Really Precisely! (1/4) Excel VBA for Beginners

Create Spin Buttons Using Excel VBA!

Download file link:

Video 1

Video 2

Video 3

Video 4

Spin buttons are another great feature of Excel. Spin buttons speed up the process of data input by allowing us to change the value of a cell with single buttons click. Cool! Correctly implemented, they can be a great time-saving feature. But, implementation can be problematic! If you have multiple rows in your spreadsheet, it can be time-consuming to creating lots of buttons. Moreover, getting them to line up neatly can be onerous. With some simple VBA coding, however, you can speed up this task and get it done with maximum precision. Welcome to the Use Excel VBA to Create Spin Buttons video series!

In the first video, Chris demonstrates how to create a button, and how to link the button to a cell. It is important to 'snap' the button to the gridlines (use the Alt key on a PC) and to ensure that row heights are consistent - this will help create a neat and tidy look.

In the second video, we look at how to use Excel VBA to create additional spin buttons. This may sound intimidating, but a basic routine like this is actually fairly easy to create. We use the macro recorder to record and examine some VBA code, then we make some tweaks to get it working for us. Finally, we add an instruction to the Excel VBA to ensure the buttons are positioned with maximum precision.

In the third video, we explore how to 'scale up' the code. Some VBA to create a single button is great, but what if we want to create multiple buttons? This involves a powerful coding concept known as a 'loop'. A loop works through a set of instructions a certain number of times, and is exactly what we need to create and position multiple buttons. Check it out!

A spin button only works if it is linked to a cell - the cell that changes when the spin button is clicked. Clearly, however, we do not want to click through all of the spin buttons to manually link each to a cell. This would not be in the spirit of the video series! Can we achieve this using VBA instead? Find out in the last installment of the Use Excel VBA to Create Spin Buttons video series!

Was this video series helpful for you? What have you used spin buttons for? Do you have any feedback on the video series? We'd love to hear from you. Get in touch with Tiger using the platforms below!

For regular spreadsheet hints and tips and more on the #ExcelRevolution:

[jayantkumarparmar]

I like your teaching style. You are a great teacher and coder. I was very confused by VBA but after watching your video my all confusion has reduced to bottom.

[mchllwoods]

Thx for mentioning me Mr. Mortimer!
Wasn't excepting u to post new tutorials so fast.
Lol!!!😂

[bettygreene]

Hi Chris, I'm still catching up by going through some older playlists. I was just going to look at the tutorials on creating spin buttons, but the download files appear to no longer be available. I'm sure I downloaded some files yesterday. Is this a problem on my end, or are the older files no longer available? Thanks.

[brianpickles]

Hi Chris,
Thanks for all of your teaching efforts. Having coded in a previous life I am picking up on it rather quickly, stumbling a bit when it comes to the object oriented stuff though, but I will persevere. One idea for a tutorial I had, and have not yet seen on your channel would be 'back calculations'. eg: in this tutorial you enter quantity and calculate total cost. How would you modify this spreadsheet so that either quantity, or total expenditure could be entered. Again eg: I want to purchase $30 worth of anise and 4 bulbs of garlic. Clear as mud?
If you have already covered this at some point then I will find it, in time.

[grabbinithigh]

HiI was wondering if this is possible. Scenario: I've created a search function which allows me to write the 2 or 3 first letters of a company and then press alt+q to find the company in the list below in the same document (or more if there are more with the same matching criteria). I now want to:1. Have this search function (or equivalent search function) in another document.2. Get the information from the closed workbook (where the search function originally was)... and here's the tricky part:3. I want to search in the A column for the company but get back the mailadress in the E column. So for example, in my new workbook, I write goo, press alt+q, excel finds google in A34 and gets me googles mailadress in E34.
Are you with me? Thankful for answer and thank you for awesome video tutorials, you teached me everything! /Jesper

[NetPro]

Missing Download file link from the description