Question on how to hide object in Excel with VBA What VBA line of code would you use to hide the named shpSaucer object in Excel? Select your answer below, and try not to take a sneak peak. A. Shapes.Range(“shpSaucer”).Show = False B. Shapes.Range(“shpSaucer”).Visible = msoFalse C. Shapes.Range(“shpSaucer”).Hide = msoTrue D. Shapes.Range(“shpSaucer”).Display = Visible Answer […]
So, in this quiz, we ask you to identify key elements of an Excel chart and ask you to identify them. Of course, we did not include every chart item. However, there are a lot of them. Keep in mind, every question has an image. Moreover, we use red callouts to showcase each question. Therefore, […]
How to insert hyperlinks in Excel This quick how-to guide shows you how to insert hyperlinks in Excel. Overview So, in this tutorial, we show you how to place links on text and on images. Essentially, both methods are the same. But, we want you to know ahead of time, that image links are also […]
Keep the size and position of an object in Excel This quick tip video shows you how to keep the size and position of an object in Excel. So, whenever you resize a column or row in Excel, the object under that position may move or change in size. Depending on what you want to […]
The LEN worksheet function in Excel returns the number of characters in a text string. LEN worksheet function Here is the syntax of the LEN function. Syntax =LEN(reference) Arguments Reference – A text string or cell range. Example(s) Example 1 Example 2 Example 3 Excel functions Reference home
Line chart with high low bars for Excel Sometimes, you may see a line chart like this on TV, on business channels. Now, the high-low bars may look different. But, it is the same concept. Requirements Microsoft Excel 2007 or higher or compatible Download Chart library
Link a cell to a shape This quick tip video shows you how to link a cell to a shape in Excel. You know what is funny, sometimes we actually want to use macros to do things. However, you do not necessarily have to use macros to do things. The video So, we have two […]
This quick video tip shows you how to link cells to fancy balls in Excel. Those balls look good! Just imagine what you had to do in the old days to accomplish this task. Link cells to fancy balls So, what we want to do is have a set of balls update when we update […]
Macros are a set of commands or instructions to help you complete tasks that you may do often. Overall, it is a group of step-by-step instructions. Each task runs one after another. In addition, you can test and monitor your steps within the macro. In Excel, you can use the recorder to create a macro. […]
Make a toggle button in Excel This quick video tip shows you how to make a toggle button in Excel, with a VBA macro. The video The code Below is the code for the toggle button. As you see, we use an IF…Then…Else statement to make the button work. Also notice, only one equal sign […]
The Marimekko – one level chart Believe it or not, the Marimekko – one level chart, is actually an area chart in Excel. Now, isn’t that something? It is a unique chart. And, in the beginning, it took a while learning how to create it. But now, we have one where you can just plug […]
Matches is an Excel game where you match Wingding characters. Overview of Matches So, there is not much to say about this game. You already know what it is. Simply click on one box, take a look at the character. Then, you click on another box, see if it matches the first box. Matches live […]
