.Select selecting multiple sheets in a form

[Kris_cs1]

Hi,

I have a form that is called from "Sheet1" with a button on it. When the user clicks the button, a function is called, the form is unloaded and "Sheet2" is selected.
However, while "Sheet2" does get selected, "Sheet1" is also still selected, resulting in any new changes happening to both sheets.

For example:

Please Login or Register  to view this content.

After this is run from "Sheet1", "Sheet2" is selected correctly. However, if I type something in cell A1 in "Sheet2", it also appears in cell A1 in "Sheet1", unless I manually deselect "Sheet1".

I assume I'm doing something stupid but I've tried lots of different things with no success and have also searched for answers. From what I can tell .select should ensure only one worksheet is selected.

Thanks,
Kris

[mehmetcik]

Try

Please Login or Register  to view this content.

It looks like quitting the userform is making excel read the next line like:-

Please Login or Register  to view this content.

[stnkynts]

unloading the form before or after won't make a difference. Unloading it twice is redundant. There is something else going on with other code that is causing you issues.

[Kris_cs1]

Yeah, thanks mehmetcik, but I've tried that before and it didn't work unfortunately.

unloading the form before or after won't make a difference. Unloading it twice is redundant. There is something else going on with other code that is causing you issues.

The same thing happens if you create a brand new sheet with no other code.

[jindon]

How about

Please Login or Register  to view this content.

[Kris_cs1]

How about

Please Login or Register  to view this content.

Thanks, but no luck.

[Kris_cs1]

You can download a quick example file here

[jindon]

I have downloaded the file and it is working correctly. No selection of Sheet1.

Default "Replace" protocol of Select method is True, so it is not required anyway.

I think you need to fix/re-install your Excel....

[Kris_cs1]

That's strange..
I will do a re-install and report back.

[Kris_cs1]

After re-install:
If you navigate cells with the keyboard, it still types in "Sheet1" and not "Sheet2". However, if you use the mouse to click on a cell in "Sheet2", it works as expected. Strange behaviour but I can live with it.
However, if you use the button and then try and close Excel with the 'X' in the top right, it doesn't work for me. You have to change sheets for it to regain its ability.
Again, not a huge problem but weird...

[jindon]

Hummm, I can not replicate your problem here.
Everything is fine....

[Kris_cs1]

That is bizarre!
If it's just my computer then it doesn't really matter then I suppose. Thanks for the help.