VBA to format an object

[primed]

Hi,

I am trying to change the colour of an object using VBA.
The following formula returns the correct number value. A number from 1 to 9

=SUMIF(SCENARIOS!A6:A600,chosenUID,SCENARIOS!E6:E600)

The result of the above formula is contained in the name of the object ie "Multiply 1" through to "Multiply 9"

Thanks
Primed

[noboffinme]

Hi Primed,

What is the object?

Can you post the file.

Thanks

[primed]

Hi,

File attached.

If you know how to draw the baseball home run fence feel free.I've tried a few times but cant get it to look right.

Primed.

[noboffinme]

Thanks,

Are you creating a game?

[primed]

Hi,

I wouldn't give it game status, more of an experiment at the moment. Slow going with my limited programming knowledge.

Primed

[noboffinme]

OK, If you want to go for a game type application, the below link might help.

You may need the VB type environment to build this.

The VB Express app is available for free.

I'm not trying to advise you to go to VB but it using the same language & can produce the result you might want.

If you have a look at the series from this guy, you may get some inspiration for your idea.

Hth.

[primed]

Hi Hth,

Happy new year.
I watched quite a few of the tutorials and got lots of inspiration however i kept running into issues with the software being out of date for my new computer. Then of course once i installed the updated software the code wouldn't work. I think i'll stick with excel for now to get the concept done then employ a professional later.

I sussed out the format using the record macro and cutting and pasting the code.

Thanks
Primed

[noboffinme]

No worries.

Btw, Hth means 'Hope this helps'

[xlbiznes]

Try this code to change the background color of the shape object.

Shapes("Multiply 5").Fill.BackColor.RGB = RGB(255, 0, 0)
'or
Shapes("Multiply 5").Fill.BackColor.SchemeColor = 1