VBA Form Command Button Picture Question

[CMAnslow]

Hi,

I wonder if anyone can help me?

I have an excel form with a command button on. I would like to set the picture of the button based on an image in my worksheet. I have tried the following but doenst work.

cmdShowFiles.Picture = Worksheets("Images").Shapes("CopyFiles")

Can anyone tell me how I can do this?

Thanks Chris

 

[diddi]

have you used an activex control?

 

[CMAnslow]

Hi,

Yeah it is an activeX Button from the toolbox.

Regards
Chris