View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Strange (forms) ListBox behavior

Rnning Excel97 SR2 on Win2000

I have a listbox on a spreadsheet. Selection from the list causes selection
of another worksheet in the workbook. This part works great.

But - once on the other worksheet - the listbox macro is still being
activated.#@#@!#@@@! Even happens when I have another workbook opened and
select a cell. Got around this by putting in an
If activesheet.name = ..... then

Does anyone have a clue why this might be happening?

As always - any help is appreciated!
Thanks in advance!

steve