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.
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”.
With these steps you’ll have explained the active main window the “ Developer ” tab, you can get it at the end of the toolbar.
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”) 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.