Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Drop a text box/ text

Posted on 2012-09-06
Medium Priority
Last Modified: 2012-09-06

If cell H5 = M, i would like to provide some information to the user of the spreadsheet. I dont want this info just hanging around the spreadsheet when H5<>M.

So should i call this via a text box or something. Could i have some code that would call this data from a text box or somewhere and place it under the H5, around cell H7


"xyz xyz"


Question by:Seamus2626
LVL 14

Accepted Solution

frankhelk earned 2000 total points
ID: 38371428
Hmmm - that wouldn't need (VB/Macro) code anyhow.

Just place something like this in a cell beneath and give it some appropriate formatting if needed (display multiple lines, automatic row height, etc.):

=IF(H5="M";"Text to be shown";"")

Another attempt might be thru conditional formatting.

Author Closing Comment

ID: 38371442
Simple solutions are the best!


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question