Filling command button with image

[Josh Sale]

My Excel 97 - Excel 2003 program creates a small Forms.CommandButton on
worksheets. The command button has no caption but I want to fill as much of
the button face with an image as possible.

I use code like the following:

myBtn.Object.Picture = LoadPicture("myImage.gif")

I've tried creating the image as a GIF, BMP or JPG and I always get the same
result ... a small image centered within the button. I can't fill the whole
button face with the image the way I want.

I've tried setting PicturePosition = fmPicturePositionCenter and that
doesn't help. I've also tried setting PictureSizeMode but that property
doesn't seem to be supported.

Any suggestions?

TIA,

josh

 

[N10]

HI JOsh

I tired this with various files and got both satisfactory results (ie button
filled) and also duplicated your result.

It appears to be to be a fubction of size of the imported picture as to
wheter or not it has the capability of filling the button.

For example a 27KB bit map impage failed to fuill the button ; remaining
central and small even with adjustment of the properties.

Hope this helps

N10

 

[Josh Sale]

N10,

I appreciate your response and am glad to hear that at least some of the
time you were able to reproduce my result.

However, I still don't understand what the "rules" are to achieve success.

Did you notice any patterns?

josh

 

[N10]

Hi JOsh

I didnt replicate it exhastively I will leave that you now that you know
size of input file may be a factor.

Try saving your image file in different sizes and notice how that effects
import size and reaction to porperty commands. Any photo enditor will allow
you to do this.

Best N10

 

[Josh Sale]

What file format did you save your image in (bmp, gif, jpg, etc)?