Hi

I'm new to VBA programming and still doing very basic stuff.

I have a small homework to do and I'm really struggling, although I'm sure it's quite easy.

I have an excel sheet with 30 names in column A and I'm asked to do the following:

Write a procedure – a sub – that uses an input box to ask for a name. The procedure should
then scan through the names in the list to search for the name and make a message box to
state “X is not in the group” or “X is in the group”, where X is the name from the input box.

HINT: You can make a variable “found” that starts with the value 0 and gets the value 1 if the name
is found in the list.


Can anyone give me a hint more, or help. I've tried many different things, but I can't get figure out the way to have the name variable which is entered in the input box to be compared to the 30 names on the list.

Thanks so much!