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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
VBA displaying a different worksheet
0
Discussion
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: 1989) 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: 4889) 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.
Worksheets("DATAEACHSTORE").Range("A6:AO6").Activate
Thanks Carroll
I was in a different sheet copying data and then used the line below
to go to the "dataeachstore" sheet.
Worksheets("DATAEACHSTORE").Range("A6:AO6").Activate
Thanks Carroll
carroll (rep: 16) May 15, '19 at 12:37 am
Answers
1
Selected Answer
Try
Worksheets("TheName").Activate