ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Strange (forms) ListBox behavior (https://www.excelbanter.com/excel-programming/272461-strange-forms-listbox-behavior.html)

steve

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





All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com