One way to do it would be to use a list box or combobox instead of the message box. You could then use either a Select Case algorithm to distinguish between the user selections of the items in the list/combo box and which range on sheet 3 to access. But I am not going to write the code for you, because you have too much time on your hands already.