ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data validation screen size (https://www.excelbanter.com/excel-discussion-misc-queries/35180-data-validation-screen-size.html)

Brad

Data validation screen size
 
Step one - from the menu I selected data validation

Determined the settings for the data validation
Determined the title and the input message

Did not like the format of the input message - when the cursor is on the
cell that was just work on.

Therefore my question is: Can one control the size of the pop-up window
(length and height) created by using data validation input message?

Debra Dalgleish

You can't control the size of the data validation input message. If you
can use programming, you could use a textbox to display the input
message. There's an example he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Input Message in Textbox'


Brad wrote:
Step one - from the menu I selected data validation

Determined the settings for the data validation
Determined the title and the input message

Did not like the format of the input message - when the cursor is on the
cell that was just work on.

Therefore my question is: Can one control the size of the pop-up window
(length and height) created by using data validation input message?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Dave Peterson

I don't think so.

Brad wrote:

Step one - from the menu I selected data validation

Determined the settings for the data validation
Determined the title and the input message

Did not like the format of the input message - when the cursor is on the
cell that was just work on.

Therefore my question is: Can one control the size of the pop-up window
(length and height) created by using data validation input message?


--

Dave Peterson


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com