(Solved) smaller userform on top of larger userform being used as a wallpaper

[kmakjop]

Hello

is it possible to have two userform open one infront of the other? I have multiple userforms in an application i am trying to build. One of the userforms whenever it comes up i want to hide all that is in the background. The userform doesnt fill the entire screen, so must of the data still appears in the background, thats what i am trying to prevent.

what i was thinking of is whenever i call that userform via click event, i would run another userform in the background that would fill the entire screen with a picture and hide the data. The other userform i am working with would be on top of that larger userform acting as a wallpaper over the data i want to hide.

Is this possible?

[mikerickson]

Rather than a pile of user forms, have you considered one user form with a multipage control?

[kmakjop]

that woudnt work because what I really want is to hide the background data when that particular sheet is up. I wanted that for to be in front of a nice full screen image. the only way I thought of that could work was to put a image on a large userform. I also tried put a picture on another sheet and make it active when that userform pops up, but when I do that the sheet that I have the data on loses focus and the sheet with the image get acive and my calculations get messed up. So I am back to trying to use the userform to hold a large image to cover screen

[mikerickson]

"sheet with the image get active and my calculations get messed up"

That's where the problem is. Are these calculations in VBA or worksheet functions? If VBA, fully qualifying your references will make which sheet is active irrelevant to the calculation.