I want to have a drop down list of names (using a list of names on a workbook sheet) that the user can type in a name to search or scan the list. Once and if they find the name, upon some action, probably pressing Enter, I want code to be executed.

It appears that my choices are to either:
  • Use a Form Control (and I suspect at this point I could as readily use validation) to select the name (I do NOT want the user to be able to ADD a new name not on the list), then create a button to execute the code, or
  • Use an ActiveX control that I believe could do everything all rolled up in one.




I so far have been avoiding (not using at all) ActiveX just as it requires yet another level of internal security clearance. While feasible, I like keeping things simple where company security comes to play.

Am I correct in thinking I must use a two-step process if I go the validation/form control route (I should clarify that I wish to also avoid using the VBA to check for if anything has changed on the sheet and if so to launch the code, for I do not see invoking the extra overhead simply for this one task - I rather at that point go two-step).

I remember enough about this just to be a problem to myself! It has been a while since I coded last so I am remembering bits and pieces as I go along...

Thank-you!