VBA Form Command Button Picture Question

CMAnslow

New Member
Joined
Nov 11, 2012
Messages
45
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.

Code:
cmdShowFiles.Picture = Worksheets("Images").Shapes("CopyFiles")
Can anyone tell me how I can do this?

Thanks Chris
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,090,248
Messages
5,413,297
Members
403,472
Latest member
ArtisticOwl

This Week's Hot Topics

Top