So we've got this PopulateComboBox, we run that, we open up the UserForm. We have the different items from our combo box. But right now, if I select something like Sleepy, we want to do something. In particular, we want to for Sleepy, we want to be able to display the item in the column right next to it. But right now, it's not doing anything. So let's go ahead and code that button. We can click in the GO here, this is what's going to happen when that GO button is clicked. So I've just put in this code here, it's just temporary, I just want to show you how you can get the return index from a drop-down list. When we have a combo box, and you select an item, if I run something, it's going to use something known as the list index as the return value. List indices always start with 0, so Doc will be 0, Grumpy then 1, and so on. So Dopey here would give a list index of 6, because we have 7 items. And right now, I'm just message boxing that list items. So Happy then would be 2 and Sneezy then would be 5. So that's how we can use the list item to do something with. But we don't want to display the list item, we want to display the corresponding element in column B. So I'm going to just select A1, that's going to be our active cell. We're going to message box. We want to display the item in column B that's adjacent to whatever item we select. Someone use ActiveCell.Offset (ComboBox1.ListIndex) that's the list index that we return and then we're going to offset by 1 column. If I selected the first item on the list, the list index is 0. And in that case, we don't want to offset anything. So that's why we can just use the list index directly as is, and I don't need to subtract 1, which we have typically done with the offset property. So now, let's go through an example of this. So I'm going to open up my user form and now I can select, let's make sure Doc is working, and that returns A. I can go down to Bashful, Bashful should be returning E, and when we do that, it gives us E. So this is how you can use user forms to populate combo boxes with information on the spreadsheet. And then you can use the list index to output the various corresponding elements on the spreadsheet. Now, what I'm going to show is how we can remove an item. So in other words, if I wanted to completely eliminate row 5 from the spreadsheet, I can do that using this combo box. So I can select Bashful, it should remove it from the combo box list, but it should also remove it from the spreadsheet. And this will help you a lot, for those of you who are doing the assignments, assignment four. The first thing I'm going to do is I'm going to record a macro for how to delete a row. So I'm just going to right-click on that and delete. And then I'm going to stop the recording of the macro. I go over here and we see that we've put that code. That code is in the macro now. So that's how we can delete an entire row from the spreadsheet. Behind the remove item button, this is where I'm going to put the code for how we can remove that row. Now, in addition to removing the row, we also want to remove the item from the combo box. The first thing I'm going to do is I'm going to Dim this RemoveIndex As Integer. So this is the code behind what happens when that remove button is clicked. RemoveIndex is just going to be whatever they've selected on that combo box. To remove an item from a combo box, we can use ComboBox1, and I should actually use UserForm1.ComboBox. And I'm going to use that up here, too, because we have two UserForms. We don't want this to be an ambiguous name. So we can use the RemoveItem method, and we're going to remove the index that we selected from the ComboBox. So that removes it from the list, the drop-down list. Now, I'm going to take the code from the macro that we recorded for how to delete an entire row, and I'm going to implement that into my subroutine. So I've implemented that here. Recall that when you select ListIndex, it's really, you have to subtract 1. So the first element is 0, the second element it has the ListIndex of 1. So here, if I want to remove a particular row, then I have to add 1. So we're going to remove that entire row. So we're going to select it and then we're going to delete that entire row. And finally, after we've deleted that row, we just need to make the default value on that combo box equal to the first element in our list. And I'm just going to use Range("A1") to do that. So let's go ahead and see if this works. I'm going to open up my form. Let's just make sure the first part is working. So if I did something like Happy, I get C. Now, if I want to remove an item, and actually before we do this, let's set it back. I haven't reset the spreadsheet after I deleted that when I recorded the macro. So down here, on the original data tab, you can copy and paste back to the original spreadsheet. So now, let's go ahead and run this. So I'm going to select, let's delete Bashful. And when I click Remove Item, it completely removes that row, shifting everything up. And it's also eliminated it from the combo box list here. If I want to remove the first item, it's removed that first item, and now the first item is Grumpy on our list. In assignment four, you'll be doing something similar to this. You'll also be adding an item. So you'll have to record a macro for how to add a row.