Excel How do I create Fills?

  • Can anyone tell me how to create a fill..Say if i draw a square and I wanted to take a digital photo and fill the area can I do it?

  • HI

    Insert your shape and right click on it. You should get a drop down menu from which you choose format autoshape. Then choose the co;ours and lines menu. In the dropdown box labelled colour select FillEffects>Picture>Select Picture. Now browse for your picture. Double click on your picture and click OK. That's it

  • Thanks and although that will insert Picture it does not actually make a fill..What I would like to do is say take a digital photo say 2x2 of Brick and have it when I filled an area hold the same size brick but filled it with a pattern...I dont know if this make sense or not?

  • You should draw out an image control from the control toolbox. Using the default name of Image1 use the following code as a guide to load the picture and then stretch it to fill the image control.

    <code&gt;Sub FillImageControl()
    With Image1
    .Picture = LoadPicture("C:\Documents and Settings\Administrator\My Documents\My Pictures\sample.jpg")
    .PictureSizeMode = fmPictureSizeModeStretch
    End With
    End Sub</code&gt;

    If you want to Tile the picture then use this:

    .PictureSizeMode = fmPictureSizeModeClip
    .PictureTiling = True

    in place of:

    .PictureSizeMode = fmPictureSizeModeStretch



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!