RawlinsCross
Active Member
- Joined
- Sep 9, 2016
- Messages
- 437
So yes, I have a spreadsheet on which there is a command button that launches a large userform (takes up the entire screen). On this userform is a dozen or so labels populated with numbers. I have it set up that when you click on a label a graph appears showing a trend.
I'd like the ability to:
a. click on any number of labels to get any number of graphs (i.e. the userform and graphs have to be vbmodeless)
b. (here's the kicker) - I also need the userform to be in the background. What's happening now is that when I click on the second userform label to get a second graph, the userform is 'on top' again and I lose sight of the 1st graph.
The goal is to have the userform available for clicking but have all the graphs appear 'on top' of the userform.
I'd like the ability to:
a. click on any number of labels to get any number of graphs (i.e. the userform and graphs have to be vbmodeless)
b. (here's the kicker) - I also need the userform to be in the background. What's happening now is that when I click on the second userform label to get a second graph, the userform is 'on top' again and I lose sight of the 1st graph.
The goal is to have the userform available for clicking but have all the graphs appear 'on top' of the userform.