Vba Get Shape Text VBA functions are built-in functions that are used in Excel's programming environment called Visual Basic for Applications (VBA). This could be needed because you are trying to change something from a user-selected shape or you want to read-in some bit of information from the shape (most commonly the shape name or text). The ShowChanges line makes the change visible. In his case, he has an Excel table which he has exported shapes and their text using Visio’s Shape Reports feature, to which he has added a column named Layer, and he wants to assign the shapes to these layers. Use RegEx to extract message text. If ActiveWindow. In this article we first start of by making a simple bar chart embedded in a chart sheet and then use the mouse move event of the chart sheet to make it interactive. I'm suggesting that Excel can do that without VBA if you have the Description in Cells, not in Cell Comments You could put the comments off to the side like Column CA, where the user won't see them. It copies everything on the worksheet. Formatting Shapes(cells) in Visio with VBA. Shapes("Text Box 1") s = shp. 4), then double click to add a. In order for this to be done you must know the shape index. PowerPoint slides are really just a collection of objects: titles, text boxes, pictures, labels, lines, curves, and so on. The difference between a complex string and a complex shape is that a complex shape is closed: that is, it is a candidate for patterning or filling with a colour. When I return the color using the code below, it provides only a singe number, rather than the 3 numbers of the RGB index (i. To run a macro, you have a few choices. Code =====. To create a text box in Excel VBA, execute the following steps. Fields are updated automatically when you change the information on which they are based. If you push CTRL while rotating the shape it will rotate along the base of the object instead. VBA's "Shape" object provides a property called "TextFrame", which gives access to the text of any shape. Shapes If oShp. Deleting specific shapes VBA PPT I have a macro already that adds shapes and textboxes in specific locations to PowerPoint slides. One big big problem with PowerPoint is that there is no longer any macro recorder. How to Use VBA Split Function:. I’ll post them all below with a description of each, but since WordPress seems to prevent copy/paste by default, I will. Go To "Insert" Select "Module" from the menu; Find your module in the Project window; If needed, expand the "Modules. B - the debug. This is regardless of whether you are using VBA or you are trying to manually input text. Fields are updated automatically when you change the information on which they are based. After entering the values, if the user clicks the OK button or presses ENTER on the keyboard, the Input. AddTextbox(msoTextOrientationHorizontal, _ 100, 100, 200, 50) _. However, there are times when just part of them is needed while printing. Well, my previous posts about Graph Databases got me thinking if it would be possible to embed JSON text in Visio shapes in some sort of meaningful way. Shapes If sh. When I return the color using the code below, it provides only a singe number, rather than the 3 numbers of the RGB index (i. If ActiveWindow. Text that I was looking for a way to reference it without using VBA, but I. Referencing presentations, slides and shapes. Let us see how you can use the VBA “TextFrame” property in your macro to add text to shapes dynamically. Discussion: Create a text file listing where the 2-d shapes in a document are located. This blog will also post articles related to them too Happy reading. * Open up the selection pane, which should be accessed either by Home->Arrange->Selection Pane or if you have the shape selected, Format->[A. Question asked by Jagandeep Singh on May 3, 2012 Latest reply on Oct 22, 2014 by Yong Ning. Add the shape of your choice where you want the pop up to show. Yes, I want to access the properties, values and prompts of the shapes. I'm trying to return the color of a piece of text in a PowerPoint slide and then use that color for other texts throughout the presentation, as needed. I get around this by putting a Text Box on top of the shape, and then I format the text box to have no fill and no outline, so it's invisible except for the text. Working with Strings of Text in Excel VBA. Window win = visioPage2. This means you can't get information about methods and properties by recording the steps you perform to, for example, add a shape to a slide. Shapes included buttons, etc. Beneath the shape is a string of text that I wish to move with it. Shapes With VBA - Display the cell value in a text Submitted by Ashish Koul on 29 June, 2013 - 04:30 Use below lines to display the cell value in a text-box and then re-size the text-box as per the length of text. Dealing with Shape Objects. Section, 0, 1); 0 is row 1 is column here like you said. 4 Part Section >> Programming Arrays. Most slide templates come with preset text boxes. In this article, you will learn how to get color of the cell using VBA code. Shapes With VBA - Display the cell value in a text Submitted by Ashish Koul on 29 June, 2013 - 04:30 Use below lines to display the cell value in a text-box and then re-size the text-box as per the length of text. To use it, just create a new Module using the developer tools and VBA and then when you need to rename an object or shape, select the shape and run the macro. RunBegin 'and. Examples include changing size, position, visibility and fill. That´s easy to make it rotate using Selection. TheMisc Shapes worksheet from the ShapeDemos. 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…. Once we click on “Add Shapes” button, 4 text boxes will be created, since we had given 4 as input in input box. VBA Pharma Specialist® - Quaisquer soluções e/ou desenvolvimento de aplicações pessoais, ou da empresa, que não constem neste Blog podem ser tratados como consultoria freelance. Paste the below code in the module and run it. Private Sub cmdMakeComment_Click() Dim rng As Range Set rng = ActiveSheet. The below VBA code can help you to change the shape color based on a cell value, please do as follows: 1. Delete TextBox_Control on the Worksheet using VBA. Then we strip out all the extra code so we can add text to the shape. which explains why we don’t get any sub-selected shapes in a default selection – the argument says to skip them! To get the result that many of us are probably looking for, namely normally-selected shapes and sub-selected shapes, we would use an IterationMode of:. Macro - Resize Shape to Fit - ON. How to set a graph or shape in Word so it stays behind the text using VBA? In Word the option is to right click an object select wrap text and click the desired options such as behind text, in front of text and other options. Once we click on "Add Shapes" button , 4 text boxes will be created, since we had given 4 as input in input box. Where Delete is the property of Shape object. php(143) : runtime-created function(1) : eval()'d code(156) : runtime-created. Hi,InVBAExcel, it is possible customize the size of the shape to fit to containg text. To edit or modify the text (color, size, font, etc. Type 'Can be very useful when searching through all objects on a page Dim it As String Dim i As Integer Dim Ctr As Integer ''''' 'Read-only Long ''''' For i = 1 To ActiveWindow. Use : To add a new text-box using vba Sub add_textbox_VBA() Dim shp As Shape Set shp = ActiveSheet. Excel Made Easy was founded in 2002. Shames("Shape_Name"), and picking one at random. In this example, the macro will return the first 2-3 characters in italics and the name of the city or town in bold: Code for the macro:. Set/Get the alternative text to appear if the image is not loaded. Name shapes. Visual Basic 4 / 5 / 6 Forums on Bytes. Notes from slides into text document Takes the text from the notes section of slides in a presentation and makes a text document containing 2014 VBA Express. More than 90% of the macros are triggered by a click on a button located on a worksheet. Delete Replacing images using VBA. Examples include changing size, position, visibility and fill. Select a cell (where you want to get the output). Do you have any suggestion to this? Thank you very much. This example adds a text box that contains the text Test Box to myDocument. This VBA macro has a ton of great stuff! First it creates a shape and adjusts its size and location on the active slide. At Design For Use, we have been steadily dialing-up the sophistication of our wireframes using some of the powerful yet difficult to discover features of this tool. Note that you can modify the code to get a reference to the slide the shape is on: oShp. cubes, cylinders, cones) by using VBA code. So, let's write a quick bit of VBA code to get rid of all of the shapes from your Excel worksheet. Loops Back to Get the Next Slide. Macros Triggered by Clicking on a Text Box on the Worksheet. Sub Object_Types_on_This_Slide() 'Refers to each object on the current page and returns the Shapes. Please feel free to subscribe to my newsletter and get exclusive VBA content that you cannot find here on the blog, as well as free access to my eBook, How to Ace the 21 Most Common Questions in VBA which is full of examples you can use in your own code. Because VBA is an object-oriented language, you will be most effective if you understand the Word object model and how to manipulate it. It is built into the Visual Basic Editor, and has many different uses that can be very helpful when writing macros, debugging code, and displaying the results of your code. If IsTextEditTarget is True, the Text property of the Shape object returns the text of the. referencing the active shape. remove shape fill all text boxes Word VBA can someone help me with a macro to remove the shape fill of all text boxes in a document? Even when they are in a group. Bookmarks("BookmarkName"). Hi,InVBAExcel, it is possible customize the size of the shape to fit to containg text. To set a generic label in comments: Sub. The ShowChanges line makes the change visible. Name returns the name of the slide. Index” But in PowerPoint VBA, an ActiveSlide property is not exist. WordArt A feature of Word used to transform text into a drawing object. The one thing about this that may surprise people (it was a surprise to me) is that Shapes does not require a direct reference to the worksheet object that contains it (like it does if you try to use Shapes in a General code Module). 4 (20 ratings) Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately. In his case, he has an Excel table which he has exported shapes and their text using Visio's Shape Reports feature, to which he has added a column named Layer, and he wants to assign the shapes to these layers. In the event some VBA code will change the label text. In Office 2007 terminology, a PowerPoint text box is an object. How to Popup Text Box with a Single Click Using VBA in Microsoft Excel 2010. Basically the model has objects. Macros Triggered by Clicking on a Text Box on the Worksheet. In his case, he has an Excel table which he has exported shapes and their text using Visio’s Shape Reports feature, to which he has added a column named Layer, and he wants to assign the shapes to these layers. The macro will change the fill color, border and shape options to make the cell comments look better. The VBA Instr Function checks if a string of text is found in another string of text. Discussion: Create a text file listing where the 2-d shapes in a document are located. Let us see how you can use the VBA “TextFrame” property in your macro to add text to shapes dynamically. Learn how to build 10 Excel VBA applications from scratch. ALL SHAPE STYLES;. Chart and Organization charts are OLE objects embedded inside the shapes. IncrementRotation "some number" BUT it will then rotate the center of the object. Delete TextBox_Control on the Worksheet using VBA. Note use of Del key does not affect cell comments. The Visio example file and VBA classes source code are available here for. In this video I'll be showing you how to name shapes, and then reference them in your Powerpoint VBA code. Excel VBA Tips: Get Shape Properties Lately, I have been working with shapes in excel - moving, creating, making them invisible and resizing them. Windows Folder Picker. Uncategorized Add textbox on a PowerPoint ppt slide using vba, excel vba update powerpoint text box, powerpoint slide addtextbox method use on slide, powerpoint vba add or create shape powerpoint vba to add border, powerpoint vba set font colour border, powerpoint vba textbox border, powerpoint vba textbox fill color, powerpoint vba textbox. Before you proceed further, it's a great idea to save your file — be sure to save as a PowerPoint Macro-Enabled Presentation with the PPTM file extension. I want to search text in shapes on Excel and I found the following code in excel. Bottom line: Learn how to evenly space, align, and distribute shapes, charts, slicers, etc. How to insert new content after bookmark range of text in Word VBA?. Auto resize a text box to fit the content by resizing shape to fit text feature. Value) End With But I would like to set my fac= the value of what the msg box comes up with but this doesn't work: Dim fac As String. To set a generic label in comments: Sub. 2 part section >> Excel VBA and User Forms. Value) End With But I would like to set my fac= the value of what the msg box comes up with but this doesn't work: Dim fac As String. In this article, we are going to show you how to create custom message boxes in Microsoft Excel using VBA. Search formula of a Cell. Everything you add to a slide is a shape in powerpoint, for eg. On the sample workbook you can find the VBA code which you can freely use and modify. To use it, just create a new Module using the developer tools and VBA and then when you need to rename an object or shape, select the shape and run the macro. A post I made earlier required the coder to refer to a shape. Clear ActiveX TextBox Control Using VBA. When I use this code it works Sub DropDown11_Change() 'Insert Selection into fac With ActiveSheet. Therefore, in order to get full slide control in your VBA procedures, you must know how to add, edit, format, and otherwise manipulate. VBA - Add Shape to Range in Excel Posted on December 16, 2018 by Vitosh Posted in VBA Excel Tricks Adding shapes to a range in VBA with Excel is actually a trivial task, if you are aware of the Shapes. AddComment rng. If you want just the outline of a shape, choose No fill from the dropdown menu. For this I have found to get the shape window and take informations with. Testimonials. In the following post, we would like to offer you the way to print images and shapes only in your Word document via VBA. of the flowchart. Have questions or feedback about Office VBA or this documentation?. In this video, we record a Macro that adds a comment and a shape. The examples in this post are text boxes of the group form controls. VBA-Excel: Get Text from the Windows Clipboard by SJ · Published September 4, 2013 · Updated January 30, 2015 In earlier session you saw how to put text in the windows clipboard( Putting Text In The Windows Clipboard ) using PutInClipboard() and Data Object. I have the following code I'm using to show/hide multiple shape groups in Excel 2016 using VBA and macros: Find files that contain less than 21 lines of text. You can modify shapes in several ways using vba. Text="Text" Q7. Let us understand with an example: To view a textbox pop-up as you click on particular cell, you need to follow the below steps Click on Developer tab. It’s certainly not complete, but it is code I’ve used for various reasons. Deleting specific shapes VBA PPT I have a macro already that adds shapes and textboxes in specific locations to PowerPoint slides. This page provides code for the methods of the Excel class TextFrame: Characters. Now I would like to know how I can align the text After I get this licked I would like to incorporate a routine. In this article we will go over every step to create your own Geographic Heat Map Generator in Excel for USA states. A shape can be assigned a hyperlink, by RClick on shape and assign hyperlink. Text "It is now " & Format(Now) End Sub : To remove a comment, call the Comment object's Delete method. Before getting to the specific field macros, I think it is important to review a few technical issues (or perhaps quirks) associated with using VBA procedures in general and using them with the field collection in particular. Basically the model has objects. VBA String Length: How to Manipulate and Use Strings of Different Lengths April 3, 2014 by Richa Visual Basic for Applications or VBA is an event driven programming language which enhances, the applications of the Microsoft Office suite of products. One of the things you need to know when working with shapes in VBA for word, is the shape index. Shape Range Properties. Quickly get the properties that are available for an object. To analyze the text in the shape, use the. VBA can be used to make interactive charts that respond to mouse movements. As its name suggest, it is used to hold strings of text. 5 part section >> An Excel. The code below is intended to be a basic reference to anybody trying to use VBA code for Powerpoint. When I record a macro doing this, the closest I can come is code that copies new text from a cell and then selects a cell (probably where the upper left corner of the shape is located), followed by ActiveSheet. The problem is that every time I add a new slide, and re-run the macro I end with double all of the shapes. The values that you get in the Red, Green and Blue boxes can be used in the RGB function (in code, or in the immediate window at design time) to return a long value that can be put on the property sheet for a control, or used in VBA. If IsTextEditTarget is True, the Text property of the Shape object returns the text of the. Follow the below steps for this: Select all the shapes together by using the SHIFT key and click on FORMAT tab. Below is a list of Excel VBA functions sorted alphabetically. You have seen presentations where the slides are so big and detailed, which. Getting Your Text to Fit the Way You Want. More than 90% of the macros are triggered by a click on a button located on a worksheet. ALL SHAPE STYLES;. As seen in previous lessons, there are two main ways you can add a text box to a form or report:. Creating text files is easy with Excel VBA, but how do you know which method to use? To become a true file. Referencing presentations, slides and shapes. Press CTRL + F to open Find and Replace dialog. Do you have an edition of Excel with "Text to Speech" installed? If so, you can make Excel speak from VBA code. For AutoShapes, the AutoShapeType property lets you get/set the type of shape as shown in the gallery image below. In recent posts, I've discussed recording macros, fixing recorded macros, and even using someone else's macros. The text in a cell can be improved with color. While executing the Excel Macro some times you may need to send some Details or Result directly to your email ID or any other ID using Excel Macro. Setting a graph behind the text is quite useful, if you need to display some text. Is it possible to change the text of a label in a form on the event "By open". I need to manipulate 3D shapes (eg. VBA to change shape rotation Excel Programming. text selection but everytime I try to use it it states "text" does not exist for characters so I go in a circle wondering WTF when there is documentation and it references the text method but I get it does not. Name shapes. So, let's write a quick bit of VBA code to get rid of all of the shapes from your Excel worksheet. You can get the name of each Text Box and work with a named Text Box like this: Sub ScratchMacro() Dim oShp As Shape For Each oShp In ActiveDocument. Check out this page. In recent posts, I've discussed recording macros, fixing recorded macros, and even using someone else's macros. PowerPoint treats everything inserted on the slide as a shape. Windows Folder Picker. There are more VBA articles in the VBA knowledge base. A complex string or complex shape contains only linear elements. So my need would be to integrate into the code above a condition so I could add the same shape multiple times based on the value on each row in column 9. You can find similar Excel Questions and Answer hereunder 1) How can I prevent users from seeing / accessing my macro code? 2) Here a explanation about the global seek function in VBA. Shapes("Drop Down 11"). You can get the name of each Text Box and work with a named Text Box like this: Sub ScratchMacro() Dim oShp As Shape For Each oShp In ActiveDocument. Choose Edit Text from the Context menu. Item(1) For Each objSuggestion In objNode. Is there any way to access shape data information?. Is it possible to select a specific shape object on a visio page knowing either its unique ID or. Shapes fall into two main categories:. I’ve tried changing the VBA code, adding “29” in the code snippet: “Case 29, 32 To 126, 203” to be used, but the font will just show the result as an empty rectangular shape. 6 Part Section >> Conditional Logic. As the Text property is a default property of the TextRange object, we can omit the Text property. The links to the right points to different sections in this article. The mouse pointer in Excel will take on different shapes depending where it is on the sheet, and each pointer type relates to a particular action. I have used this button to create a greeting card for Christmas. VBA - Add Shape to Range in Excel Posted on December 16, 2018 by Vitosh Posted in VBA Excel Tricks Adding shapes to a range in VBA with Excel is actually a trivial task, if you are aware of the Shapes. PowerPoint treats everything inserted on the slide as a shape. Microstation V8i VBA Changing Font on Text in a TextNode not working Offline Mark Gosine Fri, Sep 23 2016 8:35 AM All I have is a single two line textnode. Text = "Test Box" Support and feedback. To add text to a shape, right-click and choose Edit Text…. How Does The Macro Work? Step 1. Text boxes and most shapes can include text in them. In this video, we record a Macro that adds a comment and a shape. SQL Databases / VBA Automation; vba code in PowerPoint to find text and format 'This is a silly procedure that cycles through all the shapes on a slide. I would like to specify a range of cells to only copy those shapes' values. I would like 1 macro to work with every shape, so if I had a million shapes, I could assign this 1 single macro to all the shapes. Most slide templates come with preset text boxes. Search formula of a Cell. hi everybody. What if you need hundred such shapes? The problem become more complex if you need them at defined coordinates. for instance: I have a rope that I drew in ACAD 3D on a vertical position (90° from the x axis, 0° from y axis). … - Selection from Programming Excel with VBA and. Inserting shapes using VBA is easy. If you later resize your drawing shape, then the text within it is reformatted to fit the new dimensions of the shape. Hi, You can get the text of any shape using the "Text" property of the Shape Object. Placing Displayed Text into Cell Comments (#cctext) The following does same for displayed text (constants and formulas). Code =====. Let us understand with an example: To view a textbox pop-up as you click on particular cell, you need to follow the below steps Click on Developer tab. Net, c# and other technologies. Sometimes we need to get an active slide number when we make a PowerPoint macro. Basically the model has objects. Creating text files is easy with Excel VBA, but how do you know which method to use? To become a true file. I get around this by putting a Text Box on top of the shape, and then I format the text box to have no fill and no outline, so it's invisible except for the text. A shape can be assigned a hyperlink, by RClick on shape and assign hyperlink. When I use this code it works Sub DropDown11_Change() 'Insert Selection into fac With ActiveSheet. ControlFormat MsgBox "Item chosen = " &. Sub LoopThruShapes() Dim sh As Shape Dim I As Integer I = 1 For Each sh In ActiveSheet. Windows Folder Picker. That is, text nodes can not be nested. For all general questions relating to Excel but not including VBA or formulas. So, I had to spend time re-adjusting everything so that the text correctly fit into the placeholder boxes. For testing I've just been using Google's homepage. 1 Creating a Pie Chart. You can find similar Excel Questions and Answer hereunder 1) How can I prevent users from seeing / accessing my macro code? 2) Here a explanation about the global seek function in VBA. How to find and replace specific text in text boxes? Find and Replace is a useful tool for us to find and replace cell contents or formulas quickly and conveniently in a worksheet. Loop through all shapes in VBA. Note that you can modify the code to get a reference to the slide the shape is on: oShp. a text box, a table or a rectangle is a shape. It is very easy to add text to shapes dynamically in Excel using VBA, provided you know the properties. Creating custom Map Charts using shapes and VBA Posted on July 24, 2017 April 27, 2019 by Excel Off The Grid Whenever I see promotional images for expensive BI Dashboard software, they always show the same thing - a map with countries or regions highlighted in different colors. Here is an easy way to determine the name of the shape or to set the name of the shape. 4 (20 ratings) Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately. Sub Object_Types_on_This_Slide() 'Refers to each object on the current page and returns the Shapes. Determine which shape was clicked. How can we get the first N words from this paragraph? An Attempt to Use LEFT() Working with the text above, let's see if we can use the LEFT() function to help us out: =LEFT(A1, 100) This asks Excel to get the first 100 characters of the long text: Thomas Edison's inventions shape every day of a modern man or woman's life. which explains why we don't get any sub-selected shapes in a default selection - the argument says to skip them! To get the result that many of us are probably looking for, namely normally-selected shapes and sub-selected shapes, we would use an IterationMode of:. Delete an image from VBA. After you get the idea, you can implement the same for other cities and countries or even situations where the shapes might not even be geographical. The code below is intended to be a basic reference to anybody trying to use VBA code for Powerpoint. Programming Excel 2007 and Excel 2010 AutoShapes with VBA (Guest Post) – Peltier Tech Blog […]. I'm suggesting that Excel can do that without VBA if you have the Description in Cells, not in Cell Comments You could put the comments off to the side like Column CA, where the user won't see them. Parent returns a reference to the slide the shape is on oShp. Looping through a Collection of Shapes. AddTextbox(msoTextOrientationHorizontal, 100, 100, 200, 50) ' add shape. More than 90% of the macros are triggered by a click on a button located on a worksheet. 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. a text box, a table or a rectangle is a shape. Right click the sheet tab which you want to change the shape color, and then select View Code from the context menu, in the popped out Microsoft Visual Basic for Applications window, please copy and paste the following code into the blank Module window. The links to the right points to different sections in this article. The difference between a complex string and a complex shape is that a complex shape is closed: that is, it is a candidate for patterning or filling with a colour. Shapes If sh. Home VBA How to VBA ON-OFF Button in Excel Today, I'd like to share with your simple steps to create an on-off button in Excel. Excel Made Easy was founded in 2002. Select Insert on the ribbon and choose Shape. ALL SHAPE STYLES;. I'll have to get back to you to verify this, but there's a few ways you can tell what a shape's name is. The 13th line loops back to get the next Slide object. "RGB" stands for Red Green Blue, which are known as three additive primary colors, which can be combined to produce other colors. Index" But in PowerPoint VBA, an ActiveSlide property is not exist. This is regardless of whether you are using VBA or you are trying to manually input text. Populating a Powerpoint Table (Group) with Data from Microsoft Excel using VBA 'Code by Mahipal Padigela 'Open Microsoft Powerpoint,Choose/Insert a Table type Slide(No. Programming Excel 2007 and Excel 2010 AutoShapes with VBA (Guest Post) - Peltier Tech Blog […]. Windows Folder Picker. At Design For Use, we have been steadily dialing-up the sophistication of our wireframes using some of the powerful yet difficult to discover features of this tool. I am writing a program using the VBA interface (through VB. To run a macro, you have a few choices. I have added a text to this Shape, say eg: "HELLO" how can I get or modify this text by vba? Happy new year!. VBA String Length: How to Manipulate and Use Strings of Different Lengths April 3, 2014 by Richa Visual Basic for Applications or VBA is an event driven programming language which enhances, the applications of the Microsoft Office suite of products. , we get this result:. VBA's "Shape" object provides a property called "TextFrame", which gives access to the text of any shape. The code you will use depends on the type of picture you want to insert. Open a new document in Word. You can fit artistic text to a path by using the Text. In this tutorial, we describe the steps to create custom, reusable shapes (data graphics) that accept user inputs (text, data) through a dialog box. com") In this example, the variable called LResult would now contain the value 20. The macro will change the fill color, border and shape options to make the cell comments look better. Howe is this achieved in VBA? Thanx in advance Piblon. I’ve tried changing the VBA code, adding “29” in the code snippet: “Case 29, 32 To 126, 203” to be used, but the font will just show the result as an empty rectangular shape. When you need to code floating shapes - images etc - onto a page you need to position the shape where you want it then you have to get the shapes location so that your code places the shape in the correct location. Have cut and pasted from a web site into Excel only to find lots of Shapes were added and didn't want any of them. 8 Part Section >> Programming Loops.