crop images in microsoft excel visual basic editor(macro)

[atiullah]

Hi,

I am using microsoft excel visual basic editor to write a code.I need to crop up a part of bitmap image. I have seen posts how to do it for a picture box but in this editor there are no picture boxes. There are just image boxes. How do I do this using an image box or is there a way to incorporate picture box in this editor?

[QVeen72]

Hi,

this is what i got from Macro recording.. try this...

With ActiveSheet.Shapes(1)
        With .PictureFormat
            .CropLeft = 600
            .CropTop = 1260
            .CropBottom = 100
            .CropRight = 1290.3
        End With
        .Left = 0
        .Top = 0
    End With
 

Regards
Veena

[vb5prgrmr]

You can add a picture box under more controls, or you can use a stdPicture object (I Think). To test, see if you can declare a variable as a stdPicture. Then use your friends (yahoo, google, ask, answers, bing) on how to use this object. If you cannot declare a variable as stdPicture, sorry to waist your time on that part. GoBack to finding the picture box under more controls...



Good Luck

[atiullah]

@vb5prgrmr
@Veena.. Thnks for your reply. I have put an image box in the userform and upload the picture there. I have to crop a portion of this image and save it as another image.How would I be able to do it?


@..vb5prgrmr ..I tried to search picture box in more controls but couldn't find it.Are there picture box controls in microsoft excel visual basic editor?

[vb5prgrmr]

Weeeellll..... There used to be... or at least I thought there was... But now I wonder if my memory is going as I just checked.... and did not find what I thought I would find.... Hmmmm,... Okay, I give up as I don't use VBA all that much...



Good Luck