Resize Validataion Message Help!
Hi,
I would like to change the size of the message box so that words don't wrap. If this isn't an option, can someone guide me to VBA code that will display a message box that I can resize when I click in a cell? I don't want to use comments, because I don't want to have to point to the cell - I need the message to display when the cell is active. -- Thanks! Dee |
Resize Validataion Message Help!
You can't change the size of a data validation input message, manually
or programmatically. You could add a comment to the cell, and use event code to display that comment when the cell is selected. dee wrote: Hi, I would like to change the size of the message box so that words don't wrap. If this isn't an option, can someone guide me to VBA code that will display a message box that I can resize when I click in a cell? I don't want to use comments, because I don't want to have to point to the cell - I need the message to display when the cell is active. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Resize Validataion Message Help!
Hi Debra,
Thanks again for this response. That is exactly what I wish to do. Do you know where I can find a "snippet" of code in order to do this? I am hoping that it is something I can run for an entire workbook or at least worksheet. Thank you. -- Thanks! Dee "Debra Dalgleish" wrote: You can't change the size of a data validation input message, manually or programmatically. You could add a comment to the cell, and use event code to display that comment when the cell is selected. dee wrote: Hi, I would like to change the size of the message box so that words don't wrap. If this isn't an option, can someone guide me to VBA code that will display a message box that I can resize when I click in a cell? I don't want to use comments, because I don't want to have to point to the cell - I need the message to display when the cell is active. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Resize Validataion Message Help!
You could record a macro as you insert a comment with the text that you
want, then modify the recorded code. There are sample macros here, that might help you, including one that shows a comment when a cell is selected: http://www.contextures.com/xlcomments03.html dee wrote: Hi Debra, Thanks again for this response. That is exactly what I wish to do. Do you know where I can find a "snippet" of code in order to do this? I am hoping that it is something I can run for an entire workbook or at least worksheet. Thank you. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 07:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com