View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Riddler Riddler is offline
external usenet poster
 
Posts: 49
Default Setting a list box to a value

The problem I have is that my list is something like this:
MES
McMaster Carr
Walmart
ABC Construction
A & B Supply

and then I want the second user form to say preselect "ABC
Construction".
I would have to write a routine to determine which line it is on in the
list box.
Just setting it equal to the other one seemed to make it preselect OK
except for those couple that I mention that just dont return what is
highlighted.

Thanks
Scott