This article provides a sample for getting the desired color code. The user selects a fill color for the cell A1. After pressing the Get Code button the color code used will be printed in cell B1. It can be seen from the figures below that
As previously mentioned in the article Excel VBA, Color Code when working with colors in Excel you must know their color code. Though sometimes you may want set the color by using the RGB color model. This can be achieved using the RGB() function. For more information
There may be times when you need to ask the user to select a file to open. This can be done using the open file dialog. Keep in mind that the open file dialogs doesn’t actually open anything. It returns the path of the file
In this article I will explain how you can indent and Outdent blocks of code. – Step 1, Select the Text to Indent: The first step would be to select the block of text you would like to indent: – Step 2, Press TAB: By
In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient colors. I’m assuming readers are familiar with the concepts explained in that article before reading this article. Jump To: Gradient Color, Range Modify Existing Gradients Color for Range – Gradient Color, Range:
In a previous article I’ve provided a sample code for getting the color code based on the fill color of a cell, Excel VBA, Get Color Code. In that example the user changes the fill color of the cell A1. After pressing the Get Code button the
This article explains how you can use VBA for Excel to automate Google Earth and set the camera to the location you want. It will be assumed there is KML file located in the path “D:StuffBusinessTempLocation.KML”. The KML file contains the required data for setting the camera
In this article I will explain how you can create a table in an external access database using VBA. Before creating a table you will need to connect to an external database. You could either create a blank access database using the topic covered in
In this article I will explain how you can get the names of all the tables in an external access database using VBA. The first step would be to connect to an external database. I’ve explained this in the article below: VBA, Open Access Database From
In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient’s color. I’m assuming the reader is familiar with the topics covered in that article. – Gradient Color, Row: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples