Excel Vba Change Command Button Text


Click the button and change the caption to “Run” (without quotes). vba Excel 2010 – evento MouseDown en el button de command de controles Active X En esta página, Microsoft explica cómo saber si se combina una combinación de Shift, Ctrl y Alt cuando ocurre el evento MouseDown:. In below Excel Sheet we have 2 controls, 1 Command Button and One Combobox. On thin ice Help!. Using InputBox Method in Excel VBA You can recieve a simple information from user using Message Box in your Excel VBA code : Yes / No / Cancel etc. The VBA Range Object represents a cell or multiple cells in your Excel worksheet. VBA - How to change font, color, etc in an email output (outlook) I currently work with a VBA that is set up to gather data then create and send an email in outlook but is wondering how could I alter the email output i. Using VBA buttons scroll down or scroll up. Buttons are also called Command Buttons. I am using activex button and in properties i don't see any text alignment option. Excel 2010 has a Visual Basic Editor icon in the Developer tab. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category. Inside the Developer tab, click on Insert in the Controls box, and then select a command button. We will make a simple VBA userform in which we will ask the user to enter his name, age, and sex. Bottom line: Learn 3 different ways to copy and paste cells or ranges in Excel with VBA Macros. Any assistance would be appreciated. The command buttons are usually placed at the bottom of the form and serve to complete the transaction for which the form has been created. When copying and pasting from a webpage to Excel 2000 sometimes buttons get copied, you can delete the created shapes. Question – I am trying to insert text into different planes (XY,XZ, and YZ). Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More Less You can edit the text that is displayed in a Form control or ActiveX control, such as a label or help information, and you can edit the alternative text description for a control. " Step 5) In next step, save code file and then exit the editor. Excel Vba : Filtering Using Text Boxes Excel Vba Stop Loop Button; Excel Vba Subtotal Simple userform with next and previous record displaying command buttons. Assign Macro to Command Button, Shape and Text Visit my other channel for Tutorials on MS Excel (in English) http://tiny. For menu items, the default is both image and text. How to capitalize in Excel with VBA. I change the Destination cell in this step. Excel VBA and Text Files. I want to change the button caption, background color, focus, font, etc. SQL does not really update just the update the criteria of the statement, it. This is the full subroutine which copies a command button and pastes it to a specific cell location. Setting up the Excel workbook The Excel workbook consists of one blank worksheet, a VBA module, and a UserForm. For that, we need to add the below code. Examples of common controls include list boxes, option buttons, and command buttons. Height = 20. Date Intervals, Formulas For Dates, Adding And Subtracting Dates, Differences Between Dates, Distributing Across Months Or Years Dates, Excel Serial Format Date, File Date And Times, Returning and Setting Dates, Finding With VBA. Captions are those that appear on your screen. Print result End Sub. Notice: Undefined index: HTTP_REFERER in /home/cocofarmhoian/public_html/v712pe5/04740. '***EXCEL BUG WORKAROUND***** 'When a command button's TakeFocusOnClick property is set to False, as it is for this button, the 'displayed size of its caption text can sometimes shrink or grow with each button-click even 'though the font size is not actually changed (i. Has there been any solution to the missing VBA in Excel 2016? I've been having the exact same issue with the same errors as OP. This duplicates the button and keeps it aligned with the other shape. Vba To Change Font Color In Cells Based On Value - Excel I'm using some basic code below in an on Workbook Open event to format cells with a value less then 2 and less than 1 with a particular color. Change the Name of the Command Button to "SubmitButton" and change the caption to "Submit". The end goal is for the buttons (more to be added if I can figure out this one). You can also resize the button while it is in edit mode. A 4 part section >> > BUY THE BOOK OF THIS COURSE ; Adding a Button to an Excel Spreadsheet. The command button is a very active control and there is always VBA code behind it. Although MS Excel has already great interface to work with rows and columns but there are always chances where existing data may be edited or deleted while working. I hope it works for you. I added the excel utility errorbar. com show printable version !!! hide the show to save images bellow, right click on shown image then save as. Access VBA – change Query criteria. c) Press the "Get Data" button d) Now in the "Edit OLE DB Query" window you can switch the command text to SQL e) then you can enter pretty much any SQL query code that you want to into the "Command Text" window. If you want to enable or disable a command button based on two cell values, such as, when value in A1 is greater than value in B1, the button is enable, else, the button is disable. Notice: Undefined index: HTTP_REFERER in /home/cocofarmhoian/public_html/v712pe5/04740. (only text). Copy and paste the 'Sheet1' code into this Module. You can use Excel in several ways to create printed and online forms. You will learn how to add a command button to a UserForm; how to change the text displayed on the button; and, how to change the name of the button. In the ActiveX Controls group, click Text Box. To create an ActiveX control in Excel VBA, execute the following steps. The first thing which I have learned about VBA was using a message box (“msgbox function”). The issue is about control of current values of factors used in an Excel file. I need to know how to use vba to change the caption in a command button on an excel spreadsheet. Activex Command Button Doesn't Click - Excel I'm having a problem in a workbook with several ActiveX command buttons. Includes 9 easy-to-adjust practical code examples you can use right now. Change the properties of the inserted command button using the contextual menu, which we get by right-clicking on the 'Command button'. Add command button on the userform from the toolbox. To make its text visible, a control shows it in a certain that, by default, is black. Excel/VBA - A macro to change the color of a row. Below is an example of moving the mouse to the top left of the screen and then clicking. Once you can see the Developer Tab – Controls Group – Insert – Form Controls – Button Click on the worksheet location where you want the button to appear Excel will prompt you at this stage to assign a macro to the button Hit Ok to place the button on the worksheet. Alternatively you dont have add a new button at all, you could just change the visible property to be true, then once it is pushed make the visible property false ActiveSheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor. Save Screenshot of Browser, Web Element(s), or entire Desktop to Excel or to a file; Copy Image directly to Excel OR to Clipboard; Change image dimensions and resize; Compare multiple image files, generating an image of differences; Cast image elements into ActiveX Image Control on worksheet or Userform!. Hello,Can someone advise me of the correct syntax for changing the caption of a Command Button in MS Excel, please? I have tried this in a function, but it does not work: ActiveSheet. Insert a command button, and right click, then choose View Code from the context menu, see screenshot: 2. I've pasted a command button into a sheet and it came in with a default name of "Button 1". To change the text in a cell, first select it. If Type is 0, InputBox returns the formula in the form of text; for example, =2*PI()/360. Users can make these changes using the Command Button Wizard, where MS Access also allows users to browse pictures from their system. Searching For Text Only. Click Customize on the left, In the 'Choose commands from' drop-down box, select Macros, select a macro name on the left side list box and click 'Add' which adds it to the Quick Access Toolbar and the macro name now appears on the right side list box. Microsoft Excel). See screenshot: 2. from the defaults. Select View Toolbars Control Toolbox from the spreadsheet menu. If Type is 0, InputBox returns the formula in the form of text; for example, =2*PI()/360. Then click on the Worksheet to add the button. Open a new Word document and press ALT + F11 to open the Editor, a. Free ms-access sample database downloads. In this tutorial we will work on excel forms and VBA and we will learn how to use excel vba to close form. If you are using a later version (Excel 2007 or later), this tip may not work for you. It means you can assign a hot key to a command button which can be triggered by pressing that hot key from the keyboard. Examples of common controls include list boxes, option buttons, and command buttons. Visible = True. ” Double click on the newly created command button and input the subroutine given above. In our project, we want to change the values in A1 to Item, B1 to Price, C1 to Quantity and D1 to Total. Command Buttons in VBA for Excel. Users are then able to install your add-in, which usually provides them with a custom ribbon and modules for extended controls. This is a sample to create an Excel template for a specified purpose. First open the editor, add a module, copy the macro below into it, and link it to a formula button (refer back to the previous page if needed):. To change the text in a cell, first select it. A toggle button can be a useful tool in conjunction with a command button. I am using Office 2007 Excel. DrawingObject. Left-click the shape and change the text to match one of the other pivot table fields. Excel MVP Jordan Goldmeier will let you know how to make Radio Buttons larger with Excel VBA. Paste clipboard contents. You can even combine two or more buttons (and icons) by simply using the + symbol. Get Started with User Forms; User Form Buttons; Launching your User Forms; Add New Tabs to the Ribbon; Customize the Excel Ribbon; An Excel Picture Viewer Project. To do so I will draw on a procedure demonstrated in the List Unique Items with VBA article. To see if the button works correctly we first need to change again the value in cell B3. What you can do is create a button with the program with text or pictures or both and then you save the button as an image take it in to paint or photoshop and the resave it as a. I am using Office 2007 Excel. Introduction. The text will change depending on the position of the button. In Excel other than All these VBA controls like Command Button, Radio Button, Textbox etc. Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More Less You can edit the text that is displayed in a Form control or ActiveX control, such as a label or help information, and you can edit the alternative text description for a control. Step #1 Open your form under the design view and click on the button or text box that has a function/command behind the button/textbox. We will learn to create a VBA form for data entry in MS Excel. Learn more about keyboard shortcuts in Excel for the web. The Choose a Query dialog displays defaulting to the Queries folder. VBA Text Box is one of the controls of the many controls of the User Form. Let us assume, I have a list of data (or a. My hope was to replicate the sheet exactly with buttons. I have a calendar control on the form that starts out being invisible. The above image will give you idea about what I am trying to explain. ActiveX controls can be used on worksheet forms, with or without the use of VBA code, and on VBA UserForms. Note that the thread seems to reference only buttons with text, but the buttons I am using all have images assigned rather than text. Excel is great for manipulating numbers, but it does not always make clear how to format text values the way you want. If I use this routine, it works: Private Sub Worksheet_Change(ByVal Target As Range) Me. I use thetextbox for entering numbers (ammounts of money). Note Labels size should be bigger than command buttons size( You need to paste or add command button over the label) Step 3 Add a shape which you wanna show on the mouse over and give it some name For example Mouse_t_1 To change the name of image. htm) Create a new sheet named with the text value of a cell with a changed value in Column F (col 6). Is there a way to change font size of Command Button inserted via Design Mode, Active X Control. Repeated use gets repeated shrinking to the point where I can no longer read the caption. To change the caption of the labels, text boxes and command buttons, click View, Properties Window and click on each. Please replace the original code with the following VBA scripts as you need:. There are many reasons for avoiding shared workbooks in Excel. ) The Paste Special command is a good example. Give the button a suitable caption, e. vba Excel 2010 – evento MouseDown en el button de command de controles Active X En esta página, Microsoft explica cómo saber si se combina una combinación de Shift, Ctrl y Alt cuando ocurre el evento MouseDown:. Excel provides the text worksheet functions, namely the Upper Function, the Lower Function and the Proper Function, which can change the case of a specified input text string. I have created a GUI using VBA for an EXCEL sheet. Public sub XmlHttpTutorial End Sub Define XMLHttpRequest. The Quick Access Toolbar (Toolbar Button): Click the Office Button (top left of your excel window), click Excel Options which opens the Excel Options dialog box. Controls can take the form of a TextBox (used to enter free text), a ComboBox (which offers the user a drop-down list of options, an Option Group (where the user can make a choice by clicking Radio Buttons), a Check Box (where the user places a tick to select an item) or a Command Button (that the user clicks to give an instruction). (For buttons, the default is image only. The text will change depending on the position of the button. Change Form Button Caption. You will in this article learn how to: Insert a button (Form Control) on the worksheet; Change the size of the button. I am not able to find option to change these settings manually. Displays a message box with the value held by the variable. The examples here are straightforward illustrations of easy techniques to create charts, add and remove series, and move and resize charts using VBA. I added three basic elements: a command button, a label, and a textbox so our userform is not just an empty box. I want to change the button caption, background color, focus, font, etc. Excel will ask you to assign a macro to the button. Then change the value in the active cell to whatever you want, just put it between double apostrophes. to explain more, i have a userform with a textbox, a label and a command button. If you select the OK button, InputBox returns the value entered in the dialog box. Excel Exam 2. You could use Excel VBA to move the mouse and click on things (left and right click). The following is the code for the main procedure;. Excel has two choices for the same control. On running the code the command buttons size and caption alternates. Working with Chart Objects in VBA, dynamic query. Insert a command button on the UserForm as shown below − Right click on the command button. DoCmd SendObject Command in Microsoft Access: Features and Limitations for Sending Emails Sending emails from Microsoft Access databases is a very powerful feature. Here, you learn how to add controls to a VBA UserForm, give them meaningful names, and adjust some of their properties. VBA can read a text file and then write it to your spreadsheet. Names are used in the Excel VBA code. Setting up the Excel workbook The Excel workbook consists of one blank worksheet, a VBA module, and a UserForm. In the Control worksheet, enter the text shown in column A: Assign the range names shown in column A to cells in column B. In the Text Box, enter text, and it will appear in the linked cell. Once you can see the Developer Tab – Controls Group – Insert – Form Controls – Button Click on the worksheet location where you want the button to appear Excel will prompt you at this stage to assign a macro to the button Hit Ok to place the button on the worksheet. Any assistance would be appreciated. I want to change the button caption, background color, focus, font, etc. A 4 part section >> > BUY THE BOOK OF THIS COURSE ; Option Buttons and Command Buttons. I am able to use VB and Macros in other Office applications such as Word, but am still unable to get it working in Excel. to explain more, i have a userform with a textbox, a label and a command button. In the Macro dialog box, click on the macro Name – EnterTextRelRef. [RESOLVED] how to change the font color of command button in vb6 If this is your first visit, be sure to check out the FAQ by clicking the link above. The examples here are straightforward illustrations of easy techniques to create charts, add and remove series, and move and resize charts using VBA. The slide on which we have created the text boxes have 2 command buttons, one for adding text box and other one for deletion. Is there an easy way to allow text to be displayed when the user hovers on a command button - similiar to what you get when using a. In the Text Box, enter text, and it will appear in the linked cell. 2 part section >> Excel VBA and User Forms. Below is an example of moving the mouse to the top left of the screen and then clicking. Click on the cell with cell references you want to lock - in this case, C1. Write Text File in Excel VBA. Shrinking text size when using VBA command button on a form Inserted command buttons from VBA toolbar into my Excel user page and have associated code with the buttons. Please find the following steps and example code, it will show you how to add dynamic Command Button control on the userform. 12 part section >> Excel VBA and Charts. To do so I will draw on a procedure demonstrated in the List Unique Items with VBA article. DrawingObject. Solved: How to change color of Form Control Button? If this is your first visit, be sure to check out the FAQ by clicking the link above. Now, click F5 to run the macro, click 'Create_TextBox ' button to see the result. Repeated use gets repeated shrinking to the point where I can no longer read the caption. VBA - How to change font, color, etc in an email output (outlook) I currently work with a VBA that is set up to gather data then create and send an email in outlook but is wondering how could I alter the email output i. I have eight sections in this worksheet requiring a command button so wish to assign a button to each section to print out the relevant. Add a listbox and a command button. If I use this routine, it works: Private Sub Worksheet_Change(ByVal Target As Range) Me. Excel VBA Text Box. With this function you can do more complex movement and always the same in all directions in a very accurate manner. When copying and pasting from a webpage to Excel 2000 sometimes buttons get copied, you can delete the created shapes. Get text using Left, Right, Mid, Len, InStr. When you arrive at the Car frame, remember to draw this frame first before you place the two option buttons in it. Find Method Dates, Quick Entry Dates, Two Digit Years Day Of Week, Returning Nth, Day Of Week In A Month (VBA) Day. Hi, Is there any way i can change the alignment of command button to left in excel. If omitted, 'OKonly'. ActiveSheet. OpenForm and Docmd. Introduction Page layout Printing area Printing Page break View page breaks. Use the WriteHello macro that we put in our VBE. If Type is 0, InputBox returns the formula in the form of text; for example, =2*PI()/360. When copying and pasting from a webpage to Excel 2000 sometimes buttons get copied, you can delete the created shapes. I need a command button to change colors , or text when clicked , but ideally , I'd like it's reference cell , to force the command button to change colors when there is any numerical data inserted in the reference cell. Activex Command Button Doesn't Click - Excel I'm having a problem in a workbook with several ActiveX command buttons. If I use this routine, it works: Private Sub Worksheet_Change(ByVal Target As Range) Me. Hide columns using a button. It means you can perform the operation either by clicking on the command button or by pressing the hot key. After clicking on the button the UserForm opens. Below is a list of Excel VBA functions sorted alphabetically. How can I restrict Excel cell input by only Command button which I have created. My workaround has been to have the user manually switch plane views and then run separate macros for each plane. GetOpenFilename(FileFilter, FilterIndex, Title. It is working fine and executes the code I have associated with it okay. Therefore, to visually change the color of text of a control, select that control. In general, controls make the form easier to use. Press the enter key on your keyboard and do the same for the NO option button. Excel VBA Text Box. i want to sum (calculate total of) the values entered into the textbox and display them in the label (. Click it, and you will enter the Visual Basic Editor window. It can be used with Worksheet events effectively. Also, I am adding 5 seconds delay just to mimic that something is loading. Last modified: 2015/08/14 Create a New Commandbar with one Button. Note Labels size should be bigger than command buttons size( You need to paste or add command button over the label) Step 3 Add a shape which you wanna show on the mouse over and give it some name For example Mouse_t_1 To change the name of image. VBA Course: Properties In this exercise, we will write VBA code that modifies the content and appearance of cells and worksheets. I have a userform with radial buttons and command buttons. Dim xmlhttp as object Set xmlhttp = CreateObject("MSXML2. Below shown code is assigned to add button on the slide. Make the text whatever you like. Use a variable to reference a command button. When you arrive at the Car frame, remember to draw this frame first before you place the two option buttons in it. This is a 3-part video series and you can also download the file that contains the code. After clicking on the button the UserForm opens. There are two Excel VBA macros in the workbook -- one that takes you to the next sheet in the workbook, and one. Add command button on the userform from the toolbox. How can I either A) insert text into different planes or B) write code. Let us assume, I have a list of data (or a. The issue is about control of current values of factors used in an Excel file. You have to click the OK button to dismiss the message box and let the program continue - or in our case come to an end. The Microsoft Excel UCASE function converts a string to all upper-case. value = "Text Example" [/code]Cells (Row 4, Column 2) With Cells you first enter the row n. Make sure it is "OFF" or else. Excel VBA Text Box. This is a very interesting situation. If you are using a later version (Excel 2007 or later), this tip may not work for you. See screenshot: 2. Sheets(Sheetname where button is located). Like Name of the Control, height, width, Caption, color, background, font color etc. Excel Solver - Using Solver from VBA The following functions may be used to control Solver from VBA. They are also a great way to launch the VBA editor. Click the Run Saved Query button. I have a userform with radial buttons and command buttons. Here in this post, I am sharing a simple VBA macro that shows how to add events. Get text using Left, Right, Mid, Len, InStr. 2 part section >> Excel VBA and User Forms. The Control toolbox will appear, just as it does on a UserForm within the VBA editor. Select ColorCells, then click OK. You can do this with a button created in the spreadsheet using the Forms toolbar's Button tool. Using the code below, I was able to change the name of the command button, but the code did not work if it was in the same procedure as the command button creation code. Top 100 Useful Excel Macro [VBA] Codes Examples (Visual Basic for Applications) language. Update and Delete Using Excel VBA Userform, Remove Password From Excel Using Excel VBA (Coding) or you can learn much more related tips & tricks. , we get this result : There are two different ways that we can set the color : ColorIndex, which has 56 colors, or Color which makes it possible to use any color at all. You could use Excel VBA to move the mouse and click on things (left and right click). It is easy to change Query criteria in Query View, but sometimes your criteria may depend on a variable that is not a constant. Access commands and functions can be used in the VBA code set to run when form buttons are clicked or other form events run. In the toolbox the text box has this icon. Examples of common controls include list boxes, option buttons, and command buttons. Press the enter key on your keyboard and do the same for the NO option button. Open an excel file and open VBA editor (Alt + f11) > new module and start writing code in a sub. You will in this article learn how to: Insert a button (Form Control) on the worksheet; Change the size of the button. Do While Loop in Excel VBA (Using a Command Button) 8) Return to the worksheet and make sure Design Mode is not activated, enter the text Populate in the TextBox, on the worksheet as shown below. What I need is that when someone clicks on one of the radial buttons the commandbutton caption changes from 'Next' to 'Finish' Here is some of the code I have used, but when I click that radial button nothing happens. The text box is the simplest control to require an entry from the user. Excel VBA Development We accumulated the necessary experience in developing applications that are easy to use by our end customers and are easy to maintain and update by our own developers. Setting up the Excel workbook The Excel workbook consists of one blank worksheet, a VBA module, and a UserForm. First, we can move to the button to the right of the form, in a more natural position. com and fill a search form to find "excel vba" text. Use a variable to reference a command button. Then change the value in the active cell to whatever you want, just put it between double apostrophes. How to assign a VBA Macro to change the color of ActiveX command button in Excel. In all programming I generally prefer the Command Button as it is more flexible and its functioning and look can be changed by VBA code. Also, put this code in the same worksheet where this active X button is. 4 part section >> A TreeView Project. VBA - Excel Objects - When programming using VBA, there are few important objects that a user would be dealing with. To add a command button, you need to enable the Developer tab, if you haven’t already. c) Press the "Get Data" button d) Now in the "Edit OLE DB Query" window you can switch the command text to SQL e) then you can enter pretty much any SQL query code that you want to into the "Command Text" window. Count This will give you the number of Rows which are used. Select Run Sub/UserForm from the dropdown list. com ( SS64 ). Excel VBA Events: Tutorial And List With 115 Application, Workbook, Worksheet And Chart Events By J. March 01, 2015/. I'll also cover a lot of practical examples on using Worksheets. The SendKeys method has two arguments: SendKeys(Keys, Wait) The Keys argument is required, and is the key or keys that you want to send to the application, as text. Names are used in the Excel VBA code. Caption = Val(TextBox1. vbRetryCancel 5 Displays Retry and Cancel buttons. In the toolbox the command button has this icon. By using Excel VBA range object, you can refer to, A single cell A row or a column of cells A selection of cells A 3-D range As we discussed in our previous tutorial, that. buttons - Choose which buttons to display. The only way Walt's code will work is if the coder adds a command button on the form BEFORE run time, setting its style property to true. I am really good with excel formulas and can handle it really well, but when it comes to VBA, I have no knowledge of the codes. i’m used report merging macro using text box and command button. how should i do Moved by edhickey Friday, July 23, 2010 7:32 PM (From:Transactions Programming). If you would like to see that the program would indeed carry on after the message box change it to read. This is especially useful when you have many sheets. In this lesson, you'll see how to add the code for the button. To show the Userform, place a command button on your worksheet and add the following code line:. In the previous lesson, you created a simple Sub in. bmp which you can then use as an image for you button. Now click on the command button and enter the following code: Private Sub CommandButton1_Click() Label1. Use VBA and macros to automate virtually any routine task, and save yourself hours, day, maybe even weeks. This is especially useful when you have many sheets. I hope it works for you. databasedev. Working with Chart Objects in VBA, dynamic query. VBA Course: Colors. The advantage of using VBA is that you can build very powerful tools in MS Excel using linear programming. There are many reasons for avoiding shared workbooks in Excel. 4 part section >> A TreeView Project. For example, when value in cell A1 has been changed to "test", the name of a certain Command button will be changed to "test" automatically. You can apply the same technique for other form elements in Excel. Now, click F5 to run the macro, click 'Create_TextBox ' button to see the result. You have already learnt how to use a command button on a worksheet to run a macro. In the Text Box, enter text, and it will appear in the linked cell. You can also resize the button while it is in edit mode. Private Sub Worksheet_Change(ByVal Target as Range) Target. Names are used in the Excel VBA code. To add the YES and NO option buttons, locate the Option Button control in the toolbox: Draw two of them on the form. One functionality missing from the VBA MsgBox function is the ability to customize the button text. Written by co-founder Kasper Langmann, Microsoft Office Specialist. You can write an Excel VBA Macro to convert plain URLs as clickable links quickly. Names are used in the Excel VBA code. To do so, select the range A4:B9. In Excel VBA you can assign a hot key for a command Button as well. Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More Less To create a professional looking appearance for a worksheet form, you should provide a consistent format to all controls and objects, and size them appropriately. On the Developer tab, click Insert. ii Change Button Image: Lets you change the image by selecting from a list of different button images. I want to be able to select a cell/cells and then press a button to change the colour. Caption = "New Caption"Thank you very much. ocx files facilitate message all things considered in contrast in order undo 11. VBA Course: Colors.