VBA displaying a different worksheet


How do I display a different worksheet on my screen when I complete

a query in another worksheet.  I tried using .show but that didn't work

Thanks Carroll



I tend to just use a combination of activate and select
k1w1sm (rep: 197) May 14, '19 at 9:44 pm
You should make this an Answer and just give a one or two line example. I can do it but I don't want to take points that you could have for providing an answer :P
don (rep: 1785) May 14, '19 at 10:40 pm
Please refine your question. Do you wish to display a particular worksheet, the next or the previous one in sequence or in order of having been called before? You say that you want a change of sheet when a query has been completed. That sounds like a VBA event procedure triggered by the query. For that it would be necessary to understand the exact nature of the query that is supposed to trigger the change. Alternatively, you might wish to have a button somewhere (where?) that you can press.
Variatus (rep: 3758) May 14, '19 at 11:54 pm
The suggestion by k1w1sm worked.  I used .activate as follows
I was in a different sheet copying data and then used the line below
to go to the "dataeachstore" sheet.

Thanks  Carroll
carroll (rep: 16) May 15, '19 at 12:37 am
Add to Discussion


Selected Answer




Thank you  k1w1sm

carroll (rep: 16) May 15, '19 at 5:00 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login