View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default Setting focus on User Form Listbox

On Fri, 25 Aug 2006, Dave Peterson wrote:

or maybe
lbxOtherLB.topindex = lbxTerr.topindex


I didn't figure out just what this suggestion was.

If lbxTerr showed element N, I thought that maybe you wanted to have your other
listbox (delightfully named lbxOtherLB) to show the same.


There is no other listbox. The zip code selection form has closed and it
passes the state and territory to the main form. State is a combo box. A
change event on it populates the territory listbox. Then it selects the
territory that the entered zip code falls into.

Don <www.donwiss.com (e-mail link at home page bottom).