Input Value of Combo Box Dropdown Click to the Next Empty Cell (VBA)

[rieuji]

Hi. I've been looking for answers everywhere about this but I couldn't find any. Basically, I want to use Combo Box Dropdown, upon clicking a selection, I want the value to be pasted on the next empty row/cell.
So if I click the "Pineapple" in the Dropdown, I want it to be entered on Cell 4, right below the Cell 3 = "Guava". Then the process continues. I believe it has something to do with setting up the "LinkedCell" but I don't know how to do it. Thanks in advance.

 

[My Aswer Is This]

Assuming we want the value entered in column "B"
Try this:

Private Sub ComboBox1_Change()
'Modified  6/10/2022  11:12:14 PM  EDT
Application.ScreenUpdating = False
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "B").End(xlUp).Row + 1
Cells(Lastrow, 2).Value = ComboBox1.Value
Application.ScreenUpdating = True
End Sub

 

[rieuji]

This helped a lot, thanks!!

 

[My Aswer Is This]

This helped a lot, thanks!!

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.