Working With Pattern Fills A Cell Range Using The Pattern Property


Microsoft Excel is a very useful application that can use language codes to customize and use the database function data according to your requirements. Here we explain how you can work with fill patterns of a cell range using the Pattern property.

< div class="Lyte hidef lP" id="WYL_-f8QTCbFWMI" itemprop = "video" itemscope = "" itemtype = "https://schema.org/VideoObject">

Working with Patterns filling a Cell Range Using the Property Pattern

this property can set the format cells using codes, all in one very simply. Keep reading this post so you know how to do, and so you keep turning you into advanced user of Excel .

Use the Pattern property with Visual Basic for Excel

If you’re learning to use language feature code Microsoft Excel , then the first thing you have to do is to use Visual Basic for that purpose. With this editor, ready for Excel, you can work with fill patterns very easily, and that is precisely what we are going to explain now.

To start applying this property in Excel should start by activating the development tab on your spreadsheet . For this carefully follow these steps:

  • Locate the tab “File” in the main window of the program.
  • In the menu that appears, click “Options”.
  • In the window, located on the right list “Customize Ribbon”.
  • Following this, place the box ‘lashes Main “and in the list that appears in you enable the box to ‘ Developer ‘.
  • Click “OK” and presto! and you can start programming in “Excel”.

Excel developer

With these steps you’ll have explained the active main window the “ Developer ” tab, you can get it at the end of the toolbar.

You may also be interested in:

Clicking on it, you’ll see the icon to “Visual Basic” , click on to start working with patterns. In case you do not want to activate the Developer tab, simply combining the “Alt + F11” keys to the editor opens quickly.

Steps to work with patterns fill a cell range with Pattern

Now that you know how to open the editor Visual Basic in Excel is time for you to know how you will work with fill patterns. A can do internally customize the cell you require the following styles:. Horizontal and vertical stripes, intertwined, interlaced diagonally, fine or coarse, and many other points

To apply fill patterns first thing you need to do is activate this property in the Visual Basic module as follows:

  • Now the window with Visual Basic Editor , select the “Project Explorer” (default “VBAProject Project”) the worksheet that is active. If you have not placed any name, default sheet will be named “Sheet 1”.
  • Right click on it and select “View Source”. You can also do this by pressing the F7 key.
  • From the right side, you have the, there active active window ” codes” copying ownership patterns “Sub patterns” and pressing the “Enter” key.
  • After this, having clear the (s) cell (s) to which you’ll apply fill patterns, proceeds to copy the following code:
    • ‘Range ( “A1″). Inside. Pattern = xlpattern. xlpatterncheker ”
      • Range ( “A1”) represents the cell you want to apply the fill pattern
      • .

      • Interior. Pattern: To activate the Pattern property
      • .

      • xlpattern. xlpatterncheker: it represents the fill style that you want to give to the cell when copying “.xlpattern” automatically a list will be displayed with all simply select available styles you like
      • .

  • Once you’ve copied the code, just what remains is to click on “Save” and “Run Sub” (similar icon on the “Play”), the latter to apply the fill pattern to the cell.

 editor visual basic

You may also be interested in:


This way so simple can work with fill patterns a cell range using the property Pattern . Become an expert in Excel is easy by following our blog, do not miss the other issues.

How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

Deja un comentario