Color on Multi page in User form....

[Hjemmet]

Hey Excel Guru's

I need some Help to change Colour if Multi page is Activated By Double-click on Specific cell....

All the Function with Double-click works

it's the Colour Part i need...

example I Double click on Cell "B1" then the Multi page side Should Change Background - Colour So that it shows that it was That Side there
are Some kind of Open and Active and they other Side Not

Hope That was Enough Info

 

[My Aswer Is This]

So you want the UserForm Multipage Page color to change when you do what?

 

[My Aswer Is This]

A UserForm Multipage Page color cannot be changed as of Excel 2013 not sure about later versions of Excel.

Now you can place a Image Control Over Top of the Multipage Page
Set the image to the color you want
Then put your controls on top of the image.

Then you would need something like: Image2.BackColor = vbRed

 

[Hjemmet]

yes i want a Multipage to change Color When i Double click on specific cell

example....

When double click on Each Cell there is set for each Multipage's

For Multi Page 1
so if Double click on
"B1" then multipage 1 side 1
"B2" then multipage 1 side 2
"B3" then multipage 1 side 3
Ect Ect to
"B8" then multipage 1 side 8

For Multi Page 2
so if Double click on
"D1" then multipage 1 side 1
"D2" then multipage 1 side 2
"D3" then multipage 1 side 3
Ect Ect to
"D8" then multipage 1 side 8

It's they same Function for multi page 3 and 4
and they Cell's are in Row F for multipage 3 Side 1 to 8
and Row H for multipage 4 1to 8

 

[My Aswer Is This]

Well like I said:

A Multipage Page color cannot change

So you would need to put a Image Control on top of the Multipage1 Page and then write your script to change the image color.

 

[Hjemmet]

I just Read It after i have send My Message

and i am change my set up to a different Solution

Thanks For your Time to Help..

 

[My Aswer Is This]

If you need more help explain in detail what your attempting to do.