Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Box Characteristic
Excel XP & Win XP
I have a file that someone else created. It has a text box that appears only when a specific cell is active and disappears otherwise. I looked in John Walkenbach's book and read where I can toggle the visible property of a text box with some event and get this effect, but this file has no code in it at all. Anywhere. I know how to link a text box to a cell so that the text in that cell appears in the text box. But that is not the case here. This specific cell is blank. How is this done? Thanks for your time. Otto |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Box Characteristic
It may be data validation. Choose Data, Validation from the menu and see if
there's an Input Message or Error Alert set. "Otto Moehrbach" wrote: Excel XP & Win XP I have a file that someone else created. It has a text box that appears only when a specific cell is active and disappears otherwise. I looked in John Walkenbach's book and read where I can toggle the visible property of a text box with some event and get this effect, but this file has no code in it at all. Anywhere. I know how to link a text box to a cell so that the text in that cell appears in the text box. But that is not the case here. This specific cell is blank. How is this done? Thanks for your time. Otto |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Box Characteristic
BigWheel
You're on it. That's it. Thanks, Otto "bigwheel" wrote in message ... It may be data validation. Choose Data, Validation from the menu and see if there's an Input Message or Error Alert set. "Otto Moehrbach" wrote: Excel XP & Win XP I have a file that someone else created. It has a text box that appears only when a specific cell is active and disappears otherwise. I looked in John Walkenbach's book and read where I can toggle the visible property of a text box with some event and get this effect, but this file has no code in it at all. Anywhere. I know how to link a text box to a cell so that the text in that cell appears in the text box. But that is not the case here. This specific cell is blank. How is this done? Thanks for your time. Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
Conversion to Text file format error | Excel Discussion (Misc queries) | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |