If rows contain certain string of text, then select range

[NichoD]

Hello, I have a question regarding VBA.
As you see in the extract below, my worksheet contains dates in column a and different text strings in column b and c.
I want to create a range which only include the cells from the last value in column a (in this case A9 through C13).
Also, I have crated a userform in which combobox you can select between "item1", "item2" and "item3". In this case, if you choose item 1, select the range including A9:C10, if you choose item2, A13:C13, and item3, A11:C12.


I hope I have been clear enough, I cannot find any help from google...

 

[NichoD]

I see, that is logical!
Once again, thank you so much for the help!