Excel Vba Shape Line Properties

But the column can be a number or letter: Both the lines above refer to the cell A1. In the VBE Editor set a reference to "Microsoft Visual Basic For Applications Extensibility 5. Height & Width of Shapes / InlineShapes in Word Document (Word VBA) Figures are embedded in the word document and when they move they are a nemesis. NET [Book]. Bottom line: Learn a few ways to apply conditional formatting to shapes. Programming Variables >. Excel ColorIndex. This tutorial will show you how. To remove the outline entirely, say from a textbox where you want only the text to appear, use shp. Section 2: Excel VBA Vocabulary (Chapters 11 to 23) Developing a macro is communicating with Excel and to do so you need to use a language called Visual Basic for Applications (VBA). Color = 3394611. There are a ton of things you can do with VBA and Excel charts. Now all your shape objects have been wiped out! Tagging, A Simple Solution To Track Your Shapes. This seems easy, but because excel codes the location of an object from the top left of cell A1, it makes it very difficult to work out exactly where the object is on the page. (Word for the web doesn't support shapes. The Excel ‘Find’ method, as you may have suspected, helps you find data in a spreadsheet. T he addShape() method has the following prototype: AddShape(Shape_type, Left,Top,Width,Height). To create a spin button in Excel VBA, execute the following steps. Bit faster also when you run your code but you can have problems when you distribute your workbooks. AddShape _ (msoShapeOval, 100, 150, 100, 100) ・額縁. ConceptDraw V is cross-platform software with powerful drawing capabilities, extensive libraries of shapes and advanced data exchange features Commercial 34. More void PickUp Copies the formatting of the specified shape. The name of the shape is taken from the Excel Macro Recorder and in my case I use two forms - msoShapeDownRibbon and msoShapeUpRibbon. Argument Settings BeginX The horizontal coordinate for the … - Selection from Programming Excel with VBA and. AutoShapeType. SelectAll Selection. Change Button Colour with VBA. Code line:. When you insert a new worksheet, it’s an event. Linked files in Excel (#linked) The first line is the way a link displays, the second line is how you might type it in the third line is how you might code the line for use in INDIRECT the fourth line invokes a user defined function (UDF). The text can be positioned horizontally or vertically, and it can appear on one line or wrap to multiple lines. The PowerPoint FAQ site - PowerPoint Help, Hints and How-tos, PowerPoint Answers, Add-Ins and Assists, PowerPoint Tips, Tricks and links to other PowerPoint sites. The VBA Cheatsheet is a an overview of a variety of ready VBA. VBA - Color/Colour Shape Fill and Line VBA to create a. ForeColor = vbGreen Then b = a + 1 Sheet1. Here is a simple example to get the height of the Shapes. ) To add a shape, select Insert on the ribbon, select Shapes, and then choose a shape. VBA - Excel Macros - In this chapter, you will learn how to write a simple macro in a step by step manner. I attempted through this guide to tackle the most general ones, but please don't hesitate to leave a comment if there is something that you would like to see added to the code in this VBA guide. Re: Unable to change Sheets(). The name can be accessed using Shape. Reading document properties with VBA Posted on June 5, 2017 December 28, 2018 by Excel Off The Grid In the Windows Explorer it is possible to view a document’s properties. i want make the “way of plot chart ” and “vba way of plot shapes” of coordinates to solution the problem of wrong zig-zag lines, i want import the xml and plot them. expression An expression that returns a Worksheet object. Pop-up Excel Calendar is a date picker for Microsoft® Excel®. In VBA, declaring variables is optional, but you can’t declare AND set the variable at the same time. To insert macros, open the VBA window (Alt+F11) and insert a module and copy/paste the following codes into the module. In Excel VBA , we can write code to create charts and graphs easily based on the data on the spreadsheet. 12 part section >> Excel VBA and Charts. List Properties Of Shapes - Free Excel\VBA Help Forum Ozgrid. Type and Shape. Macro Example Sub DeleteShapes_ActiveSheet() Dim shp As Shape For Each shp In ActiveSheet. This is a great technique for dashboards and interactive reports where you don't want to be confined by the worksheet grid. Using Vba To Automate Ie And Input User Name, Password, And Hit Submit - Excel I'm trying to use VBA to go to a website that requires a User Name, Password, and a Submit Button. In this article I will explain how you can modify border thickness and style using VBA for Excel. Each sheet has a table in the range of A4:AA500. Now, this is working fine for me. For example, purple is a mix of blue and red. This will make your code easier to read. We can add various type of shapes in Excel. Cells(i + 1, 2) * 255. VBA Shape Properties. Learn more about the Workbook and Worksheet object in Excel VBA. The flexibility of the VBA buttons argument makes it easy to customize your Excel message boxes. NET [Book]. An object accessing the line formatting of the shape. I've been looking all over to find some code that will allow me to alter the properties of one or more shapes that I manually select. If the shape is a picture it will modify its border; Sub Example2() Dim intCount As Integer Dim i As Integer 'loop through inline shapes For i = 1 To Shapes. Can i use workbook as source and filter it based on background cells color? Best, Jacek. Excel VBA - Cells Property. For example, the TextEffect property of the Shape object cannot be applied to shapes that do not contain text; therefore, when manipulating a shape through a VBA program, be careful to use the properties and methods that apply to that specific shape to avoid Run time errors. ) to different position and then return to it's original position. VBA Activesheet and how it compares to regular Worksheets, how to Select Worksheets, how to Activate Worksheets, Selecting vs Activating Worksheets… and everything else you need to know about the VBA Worksheet in general. The items do not have to be of the same type but they normally are. Make sure Excel is not running otherwise you will not be able to replace the file. I do not use macros that have too many lines of codes as this may confuse beginers. can set them too (see Excel VBA Help for options). Before you start writing a Macro, you need somewhere to create it! With the file open, go to your Visual Basic Editor (VBE) by pressing Alt+F11 together. You can edit its formatting quickly using the predefined options. To support colors, the Borders object is equipped with a property named Color. However, none of these tools can used for VBA in Excel. Transforming Color Codes in VBA. Use the prefixes in Table 2 to indicate scope and lifetime. textframe does yet, but it is not the culprit preventing colouring. When you select the shape, the "Format" tab is displayed. If you click the shape, a box in the top left corner of your excel workbook should give the name of the shape. Excel has a broad range of shape Types consisting not only of AutoShapes, but also connectors, lines, pictures, charts, comments, and many other graphical items. When you first add a control to a sheet, the shape name and code name match. In this situation, we need to hide them, and when we want them, we can display them at once. In an Excel worksheet, you can create lists by using the List Box control. Aleph-one ( ) is the infinite number of elements (cardinality) of the countable ordinal numbers set (ω 1 ). "A1", "A3:C6" etc. The For Loop in VBA is one of the most frequently used loops in VBA. AddLine(BeginX, BeginY, EndX, EndY) Synopsis Draws a straight line and returns the line’s Shape object. In the Format Cells dialog box, click the Font tab. Manipuler les Shapes par VBA Excel. Count 'check if the current shape is an picture If Shapes. Line and Fill Effects in Excel Charts Using VBA. Vous pouvez y ajouter des contrôles afin de mettre en place une Interface utilisateur adaptée à votre projet. Excel VBA has made charting engine as part of the Shape object. Excel VBA and Text Files. Heron's Formula for the area of a triangle (Hero's Formula) Try this Drag the orange dots to reshape the triangle. Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads. Create comment if cell value is. Bottom line: Learn 18 tips & shortcuts to save time with writing VBA macros for Excel or other Office applications. Note: If you have a particular reason for hiding a name from general view and making it accessible only from VBA, you can also use the Visible property and set it to False. So far I can get everything to work besides the Submit part. Normally it would have a name like “Group 12? but I’m giving it a more descriptive name, like “InCell_A1_Line”, where A1 is the cell hosting the formula. To remove the outline entirely, say from a textbox where you want only the text to appear, use shp. VBA to create a named range on each sheet with name of value in cell A2. VBA has its own collections such as Workbooks, Worksheets and Cells. Welcome to the p2p. In a previous lesson, you had code like this: ActiveCell(1, 2. In this tutorial video we look at how to set up a Print Button on any Excel worksheet that launches Print Preview when it's clicked. Ce document est une initiation à l'objet UserForm. In Excel 2011 for Mac, Microsoft has re-introduced VBA, and it's even finally the same version of VBA that Excel for Windows has been using all along. Shape objects that represent WordArt. I want to add some command buttons to change the color of these rectangles, but I only want those shapes I select to be changed. We will cover all the nuisances e. In an Excel worksheet, you can create lists by using the List Box control. Again, the worksheet must be protected to lock the shape, not the cells. Set/Get the height of. Bottom line: Learn how to evenly space, align, and distribute shapes, charts, slicers, etc. How to use axis in a sentence. The native table shape is supported only with PowerPoint version 2000 and above. Color = 3394611. Sort Excel table [VBA] Split values. The Font property of the Range object in Excel VBA gives access to a lot of other properties. Excel ColorIndex. The idea behind using a macro code is to automate an action which you perform manually in Excel, otherwise. You can choose a particular type of shape or different types of shapes from a list of shapes. Shapes property (Excel) 05/30/2019; 2 minutes to read +1; In this article. I've spent a good while trying to figure out a way to set positions of these lines dynamically using VBA, and I can't find anything! The closest I can find is setting the Top, Left, Width, Height and Rotation properties, which is probably the worst way possible to manipulate a line and completely unusable in a practical application. Hello, Since long time, reading some shape properties increase excel memory consumption. You can use Visual Basic within Excel, PowerPoint or Word to draw shapes, format them and even assign macros to run - this long blog gives lots of ideas of how to proceed! Working with shapes in VBA; Working with shapes - getting started; Naming, referring to and positioning shapes; Formatting shapes and adding text (this blog). Example below tries to give web automation using IE (internet explorer). Standard VB (applied to a VB form) has a simple, yet powerful set of graphics options. Imagine you have a lot of shapes in your Excel file and the shapes are all over the place! You want to organize the shapes but it seems a pain to move them one by one! What would you do? Thankfully, Excel allows you to distribute and align shapes! This is our initial layout of shapes:. In this article, we are going to show you how to create custom message boxes in Microsoft Excel using VBA. The code below will create a new Worksheet where the Shape Properties are listed under their appropriate heading. Perhaps it’s because there’s the option of sorting it on the worksheet, but that’s not always viable. expression A variable that represents a Shape object. VBA Line Numbers with CodeLiner is an Excel/Word toolbar that allows you to add and remove line numbers. Returns the glow formatting properties through the GlowFormat object. To specify the color, assign the desired color to the property. This Excel tutorial explains how to use the Excel REPLACE function (in VBA) with syntax and examples. In Excel VBA , we can write code to create charts and graphs easily based on the data on the spreadsheet. Hi, like in the topic. Open an Excel workbook. In the case above, this is the object variable my_Worksheet. To know more. Infinity in set theory Aleph-null ( ) is the infinite number of elements (cardinality) of the natural numbers set ( ). Excel VBA provides a keyword called ActiveSheet to refer to the currently active worksheet. Application. Book Description. Some Excel VBA Range properties are read-only properties, which means that your code can look at their values but can’t change them (“Look, but don’t touch”). MsoTriState. Shape Range Properties. How to create autoshapes, lines and connectors in VBA macros Part five of an eight-part series of blogs You can use Visual Basic within Excel, PowerPoint or Word to draw shapes, format them and even assign macros to run - this long blog gives lots of ideas of how to proceed!. The file contains code (VBA in the case of an. AutoShapeType. Macro Example Sub AlignToCenterInShape_ActiveSheet() Dim shp As Shape For Each shp In ActiveSheet. Your sheet name is "MyChart" and the chart is the only one on the sheet. To display text on the shape, you can use the TextFrame2 object property of the shape object. And that’s it you have now resized an existing range name in Excel VBA. For all general questions relating to Excel but not including VBA or formulas. If you are using a specific worksheet, then you could in addition to Paul Kelly's code add a worksheet event in that specific worksheet like this: [code vbnet] Private Sub Worksheet_Change(ByVal Target As Range) If Target. Resizing and Moving Excel Charts with VBA. To change the names and captions of the controls, click View, Properties Window and click on each control. For ComboBoxes with multiple columns, change the ComboBox properties, to increase the number of columns, and set the column widths. The code used for this example can be seen below: Private Sub btnRun_Click() Dim intLineStyle As Integer Dim intThickness As Long. Instructions on how to install an add-in To replace existing add-in with later version you simply need to overwrite the existing add-in. Using Vba To Automate Ie And Input User Name, Password, And Hit Submit - Excel I'm trying to use VBA to go to a website that requires a User Name, Password, and a Submit Button. Can i use workbook as source and filter it based on background cells color? Best, Jacek. Adding shapes to a range in VBA with Excel is actually a trivial task, if you are aware of the Shapes. For a new line to be displayed in an Excel cell, the Wrap Text option must be enabled. Cells(3, 1) = b End If End If Next Here: If Shapes. Microsoft Access / VBA Forums on Bytes. AutoShapeType. It looks like these formatting options are implemented somewhat awkwardly in Excel 2010 and 2013: The line color and properties are set as the macro code has recorded them, using the Series. VerticalAlignment = xlVAlignCenter End With Next shp End Sub. This example adds a blue dashed line to worksheet one. How to Use VBA to Access the Equation of a Trend Line on Microsoft Excel. The number 3394611 is a color code. a whole number). Copy table criteria. Returns a LineFormat object that contains line formatting properties for the specified shape. I want to add some command buttons to change the color of these rectangles, but I only want those shapes I select to be changed. This way I can bucket the shapes based on my tags. Learn more about the Workbook and Worksheet object in Excel VBA. Excel VBA has made charting engine as part of the Shape object. The information in this article applies to Excel 2019, Excel 2016, Excel 2013, and Google Sheets. can set them too (see Excel VBA Help for options). A newly formed group of shapes: The Group or Regroup method of the ShapeRange object to group a range of shapes and return a single Shape object that represents the newly formed group. The items do not have to be of the same type but they normally are. Convert one or more MS Excel template files (. He also extended it to the area of quadrilaterals and higher-order polygons. Scales the height of the shape by a specified factor. VBA Code to display messages on Status Bar of Excel. Checks if the shape object is a picture. Make sure Excel is not running otherwise you will not be able to replace the file. It allows you to pick or select a date value from a calendar that pops up at the time when you need to enter a date value. Setting this property for a menu item overrides any custom help information set up for the menu item with the information set up for the assigned macro. All trademarks and registered trademarks appearing on oreilly. Microsoft Access / VBA Forums on Bytes. Writing Excel Macros with VBA 2nd Edition Replace Shapes. In fact, a shape can have a total of 139 of them. This Excel VBA macro aligns text to the center in all shapes on an active worksheet. Pop-up Excel Calendar is a date picker for Microsoft® Excel®. You can display stages of your Marco on the status bar or use it as progress bar. Line and Fill Effects in Excel Charts Using VBA. Create a new Microsoft Excel workbook and save it as Excel Macro-Enabled Workbook (*. The items do not have to be of the same type but they normally are. Here you will notice that a particular inline shape has been singled out. Thus, a ColorIndex of 1 is the first color in the palette, 2 is the second, and so on. Shape objects that represent WordArt. Note: Print this page, open Excel and a open a new workbook. Transforming Color Codes in VBA. Learn how to work with Excel VBA object properties now. You will learn the basics of VBA such as variables, loops, procedures and functions. The flexibility of the VBA buttons argument makes it easy to customize your Excel message boxes. Ever have an instance where you have a TON of shapes or images on your spreadsheet and you need to change the Object Positioning property for all of them? It can be a hassle to individually select all the shapes on your spreadsheet (especially if you have a large amount) and tweak their object settings. If you have a textbox that is set to show the value as a hyperlink, so that the user sees the hand/finger cursor. Writing Your Own Functions In VBA. Returns a LineFormat object that contains line formatting properties for the specified shape. VBA provides a handle to a chart object using the “ChartObject” class and to the chart data series trough the “Series” class. Now, if the above line returns True. Copy table criteria. Of course you could use the normal Print function (with. How to get selected shape in excel vba? Once you know it is a shape, you can assign it to a Shape Object and use the usual properties, such as name, to examine. For Each pptSlide In pptPres. Go To “Insert” Select “Module” from the menu; Find your module in the Project window; If needed, expand the “Modules. Excel VBA and Embedded Charts This tutorial follows on from the previous one on Chart Sheets An embedded chart is one that is on the same spreadsheet as your data, rather than in a sheet all of its own. The Holy Grail of Excel Tips $12. Select ShowCode. Learn how to use various form controls & user form features in this section. Required: PowerPoint 97 or later. occurs only on excel 2007. WORKING WITH SHAPES. So VBA must wait until the code in the Sub is running before it can create the object. G6 apply angle facts, triangle congruence, similarity and properties of quadrilaterals to conjecture and derive results about angles and sides, including … the fact that the base angles of an isosceles triangle are equal, and use known results to obtain simple proofs. Select a chart, then record a macro while you move it and resize it. In this situation, we need to hide them, and when we want them, we can display them at once. Free download vba code excel calendar Files at Software Informer. Shapes / Shape Groups in Excel VBA Is a "Group" of shapes in Excel just a collection or array of references to a number of shapes? If so can a specific shape belong to multiple "Shape Groups" at the same time?. List box in VBA is a list which is assigned to a variable and the list has various inputs to select upon, from the list box we can select multiple options at once, list box can be made to a userform in excel VBA by selecting the list box option and drawing it on the userform for a list box we have a named range which has certain values provided to select in a list box. Excel has a broad range of shape Types consisting not only of AutoShapes, but also connectors, lines, pictures, charts, comments, and many other graphical items. In this example, the worksheet has a List Box control that allows multiple items to be selected, and there is a check box at the left of each item. In Excel 2010 go to the File tab, click Info then choose Properties and Advanced Properties to open the Properties dialog. T he addShape() method has the following prototype: AddShape(Shape_type, Left,Top,Width,Height). Weight = 2. i_excel PS I am not sure what. How to quickly delete all autoshapes in Excel? If you want to get rid of the auto shapes in Excel, you may look for an easy way to delete all shapes quickly rather than removing auto shape one by one. Count 'check if the current shape is an picture If Shapes. The VBA Color property is a more convenient way of defining the. Visible = True End With. Change the third argument to FALSE and watch the shape disappear. If you want to use For Loop to loop through each object, you have to use Shapes. Bottom Line: Learn how to select several shapes at once, including charts, slicers, images, etc. Naming a shape is just like naming a cell. a straight line about which a body or a geometric figure rotates or may be supposed to rotate…. Argument Settings EditingType … - Selection from Programming Excel with VBA and. You can change the direction of the text, and you can also change the margins of text boxes and shapes for optimal spacing, or resize shapes for a better text fit. @missinglinq Thank you missinglinq for the code. VBA TextBox Control on the UserForm. This video demonstrates how to use the Offset property in Excel VBA to select a cell x number of cells down and across. Revision v3. occurs only on excel 2007. The property worked nicely in Office 2007 / Vista. So, now you know how to add shapes and add text to the shapes dynamically in Excel using VBA. Course Objectives: 1) You will learn to automate and extend Excel by adding VBA projects to your workbooks. With ActiveSheet. It is good practice to change the names of controls. Select method as it applies to the Chart, Charts, Shape, ShapeRange, Sheets, Worksheet, and Worksheets objects. The idea behind using a macro code is to automate an action which you perform manually in Excel, otherwise. The code below will create a new Worksheet where the Shape Properties are listed under their appropriate heading. Today we are going to learn about VBA Worksheets. Demonstrate how to change color of shapes using Excel VBA If you find this video helpful please give me a like to my video and subscribe to my channel. Programming Variables >. AddLine(BeginX, BeginY, EndX, EndY) Synopsis Draws a straight line and returns the line's Shape object. The VBA code. Book Description. I am trying to draw lines with Excel VBA and it is working nicely except for 2 things, 1) How do I make the line thicker? 2) The lines that go up and to the right do not get drawn. Click on the objects browser in the code window to view all the available Excel VBA objects and its associated Properties and Methods. Bottom line: Learn 18 tips & shortcuts to save time with writing VBA macros for Excel or other Office applications. VBA TextBox Control on the UserForm. Go To Developer Tab and then click Visual Basic from the Code or Press Alt+F11. The shapes include objects such as lines, rectangles and arrows. Line and Fill Effects in Excel Charts Using VBA Connect Two XY Series Connect Two XY Series with Arrows (VBA) Fill Under or Between Series in an Excel XY Chart (XY-Area Combo Chart) Invert if Negative Area Chart - Invert if Negative ; Forms (VBA) Property Procedures - Passing Information to and from Forms ; Formula The Chart Series Formula. User Forms & Controls in VBA User forms are custom user interface screens that you can develop in VBA to interact with your users. Don't forget that we've only introduced a tiny minority of the possible customizations that can be done with VBA. The macro will change the fill color, border and shape options to make the cell comments look better. Value = "Jason" End Sub. Macro Example Sub AlignToCenterInShape_ActiveSheet() Dim shp As Shape For Each shp In ActiveSheet. Changing the text in a shape textbox. But in some cases, you may want to remove line shapes only, how can you solve it? Delete all objects with Go To Special function. 4 - Filling of Line shapes such as arrows, arc, curves and scribbles. To change the names and captions of the controls, click View, Properties Window and click on each control. This list gives you a glance of (nearly) all shortcut combinations in Excel. In-fact you can choose a style from an array of styles. How to use Excel 2010 VBA to set series line color, marker fill, and marker line color. How to Use VBA to Access the Equation of a Trend Line on Microsoft Excel. In this example, we are going to do following things. Excel Find Method in Excel VBA (Any version of Excel) I have been contemplating on writing this tutorial for a long time as I have found a lot of questions revolving around this topic. Height & Width of Shapes / InlineShapes in Word Document (Word VBA) Figures are embedded in the word document and when they move they are a nemesis. AddShape method. In PowerPoint 2010, trying to write a VBA macro to let the user enter a line with a pre-formatted style. The Properties tab of the Format Picture dialog box. keep_vba controls whether any Visual Basic elements are preserved or not (default). VBA Excel ColorIndex Property is to set color or get color for Objects like Cell color and Shape color. Name shapes. 3 Fill properties Only closed shapes have fill, which describes. When you select the shape, the "Format" tab is displayed. The text can be positioned horizontally or vertically, and it can appear on one line or wrap to multiple lines. SelectAll Selection. More void RerouteConnections This method reroutes all connectors attached to the specified shape; if the specified shape is a connector, it’s rerouted. In Excel VBA, an object can contain another object, and that object can contain another object, etc. Don't forget that we've only introduced a tiny minority of the possible customizations that can be done with VBA. Description. Required: PowerPoint 97 or later. Again, any direction is greatly appreciated. You create a Picture object and then use a series of commands to draw lines and simple shapes in the Picture object. AutoShapeType. Les UserForm (USF) servent à créer des boîtes de dialogue personnalisées. Each field in the Properties window has two sections: the property’s name and the property's value: The name of a property is represented in the left column. This video demonstrates how to use the Offset property in Excel VBA to select a cell x number of cells down and across. How to Use VBA to Access the Equation of a Trend Line on Microsoft Excel. Excel is powerful. You can change the direction of the text, and you can also change the margins of text boxes and shapes for optimal spacing, or resize shapes for a better text fit. Make sure Excel is not running otherwise you will not be able to replace the file. Change Button Colour with VBA. After that, the macro tackles the main formatting commands that I personally use the most in PowerPoint. This probably sounds quite confusing, but we will make it clear. Hi NevadaMax, Please try the above suggestions, please you have further question about Excel DEV, I recommend you post the question to the MSDN forum for Excel. Infinity in set theory Aleph-null ( ) is the infinite number of elements (cardinality) of the natural numbers set ( ). Name property in VBA but how can we access the other value (MyPic) that does not seem to change internally? UPDATED What I am trying to do is to link a cell to a picture in Excel. xltx) to regular Excel files (. GroupItems. Line 6 then applies the existing range name to the name property of this resized range variable. How to change shape color based on cell value in Excel? Change the shape color based on a specific cell value may be an interesting task in Excel, for example, if the cell value in A1 is less than 100, the shape color is red, if A1 is greater than 100 and less than 200, the shape color is yellow, and when A1 is greater than 200, the shape color is green as following screenshot shown. The same properties can be set for any shape object, except the arrowhead styles if the object is closed. This probably sounds quite confusing, but we will make it clear. Copy table criteria. Free download vba code excel save shapes Files at Software Informer. In-fact you can choose a style from an array of styles. How to create autoshapes, lines and connectors in VBA macros Part five of an eight-part series of blogs You can use Visual Basic within Excel, PowerPoint or Word to draw shapes, format them and even assign macros to run - this long blog gives lots of ideas of how to proceed!. Macro Example Sub AlignToCenterInShape_ActiveSheet() Dim shp As Shape For Each shp In ActiveSheet. The object model is the underlying structure of all the objects within Excel. More information on bitmaps in Excel can be found at More on Bitmaps. A shape can be created from a cell, from the Drawing Toolbar, from the Forms Toolbar among what I presume are many other places where shapes can be created.