Trying to change shape color when selecting toggle button - Code gives Error

[JJFletcher]

Hi there,

Trying to change Shape color when selecting toggle button - Code gives Error...

Please Login or Register  to view this content.

Any suggestions would be great!

John

[Norie]

What's the error message and on which line does it occur?

[JJFletcher]

Compile Error...

End With without With

Please Login or Register  to view this content.

John

[Norie]

John

It's actually an End If and a Next you are missing I think.

Try this.

Please Login or Register  to view this content.

[JJFletcher]

I thought this would work out for changing the colors etc... This code falls apart at

Please Login or Register  to view this content.

John

[Norie]

John

How does that code fail?

What parts of the shape(s) are you tryng to change?

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[JJFletcher]

I indicated where it fell apart...

I thought this would work out for changing the colors etc... This code falls apart at

Please Login or Register  to view this content.

John

[JJFletcher]

I probably did not explain this right...

Let's start over... I have this code and it works great - does everything I want it to do... EXCEPT

I have a Shape that is being used for the Toggle Button... There are two stages of the Text within the Shape:

Show.JPGHide.JPG

The desire is that when the user selects the button, that the Hide portion of the shape changes color (Maybe Green) when the shape button is selected... Can the below Macro be modified to achieve this desired function?

Please Login or Register  to view this content.

Thanks in advance,


John

[Norie]

John

You didn't say what the error was.

Anyway, is this one shape/control?

If it is are you trying to format seperate sections of it differently?

If you are then I think you'll be kind of limited as to what formatting you can apply, for example changing the format of the text shouldn't be a problem but I doubt you'll be able to change the format of the line differently for each section.

[JJFletcher]

Hi Norie,

So if I understand then, I will not be able to manipulate the color background of the Image2 Shape when it is on the Hide text setting to a green color lets say for example?

Thanks

John

[Norie]

John

As far as I can see you are trying to change the background colour of separate sections of the shape and as far as I know that isn't possible.

Changing the background colour of the entire shape shouldn't be a problem.

[JJFletcher]

Norie,

Thanks

John