View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default Filling command button with image

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" <jsale@tril dot cod wrote in message
...
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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.772 / Virus Database: 519 - Release Date: 01/10/2004