View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] mwheelock@ups.com is offline
external usenet poster
 
Posts: 11
Default Macro that Finds the First Value in a range using a Combobox (drop down menu)

I have a long list of countires and some info attached to them in a
spread sheet. I want to add a drop-down menu at the top of the spread
sheet that will go to the first cell in the column that contains that
text. E.G. If I choose Peru from the menu I want it to go to that
exact cell in the spread sheet so scrolling isn't necessary. Does
anyone know any VBA code that I can assign to this control?- It's
Forms not ActiveX. Thanks.

Matt