For use in formulas, google "zero width space copy", and you can find sites that will allow you to copy to your clipboard.
The syntax for the call is ChartObjects.Add(Left, Top.
The key to the ChartObject is determining its location.
#EXCEL VBA ON ERRORVBMODALESS IS BLANK CODE#
The starting point for the vast majority of charting code is to create an empty Chart.Note that this Chart is subject to the default chart template that is active and may not actually be empty (if the template has been modified). In vba you can use ChrW(8203) to access this character. Learn excel-vba - Creating an empty Chart. Basically, if you can make sure that whenever the cell is "empty" it's not actually empty but contains a zero-width space, you can get a conditional format to show your text. However, the calling procedure will resume immediately after the INITIALIZE event (and any other procedures called from it) terminates. If shown Modelessly then the userform is loaded/displayed and any code in the INITIALIZE event will execute. There's a work around that might help some people out. Once unloaded, the code will resume on the next line after the. Note that the macro only kicks into action if the cell being changed is cell B4. Private Sub Worksheet_Change(ByVal Target As Range) This would go into the code module for the worksheet being used: If you prefer to go a macro route, you'll want to create one that is triggered whenever there is a change in the worksheet. You could even, if desired, make the text in cell A4 a light gray, so it appears subdued when displayed. When someone types something in cell B4, this blocks what is in cell A4 from being displayed. You could make column A very narrow-say, about a single character wide-and then in cell A4 press the Space Bar a few times and type "Customer Name." As long as there is nothing in cell B4, what you typed in cell A4 is displayed, but it looks like it is in cell B4. Let's say, for example, that (again) your user input is expected in cell B4. There's also an approach you can use that takes advantage of the way that Excel deals with "cell overrun" when the cells contain text. If you want the wording to disappear when the customer name is entered, you could, instead, use a formula in cell A4: For instance, if the user input is expected in cell B4, you might put the wording "Customer Name:" (with the colon) in cell A4. The traditional way to get around it is to separate your prompts from your input cells. The short answer is no, this cannot be done. Sheryl wonders if there is a way to do this sort of "conditional formatting" that shows text. For instance, if the cell is empty, she might want to have it show "Customer Name," which would serve as a prompt to the user. Instead of a different color for the empty cell, she would like the empty cell to show some text. Sheryl can use Conditional Formatting to make a cell appear a certain color if the cell is empty.