Increase size of input message box

[SaraWitch]

Hello all,

I don't think this can be done, but I'm going to ask anyway just in case someone has found a workaround!

I have an input message box for the Key of the drop down options in a cell, i.e., input message reads:

Title:
Key

Input message:
A = Away
DC = Daily Call
D = Disclaimer

etc.

I have a data validation list with A, DC, D, etc... My issue is that, whilst I am within the allowed number of characters in the input message box, the actual message on the sheet does not show the full list (I have 14 and the bottom three are not visible). I don't think the input message box size can be changed, but it's a large sheet and I didn't really want the Key as a comment, or indeed to put it elsewhere.

Has anyone any ideas?

Ta muchly!

 

[johnnyL]

@ SaraWitch

Perhaps the following might help you Active X Combo Box

 

[SaraWitch]

Thank you @johnnyL. I know about Active X Combo Boxes, but these won't suit my purpose, unfortunately - I need very narrow columns (of which there are lots!), hence the requirement for just a letter and the Key...

 

[SaraWitch]

I wonder if I could I put full length text in DDL, then use a formula to replace with letter? (Still not perfect as full DDL doesn't show due to narrowness of columns!) **** MS for not showing all of input message box!

Any other ideas how to include a key without the sheet looking messy, or having to scroll elsewhere? I could add a macro button, I guess, but starts to feel a bit clunky for, what should be, a simple page!

 

[SaraWitch]

My brain is slowly ticking over! I've been experimenting with a VBA message box, but can't get the Key in list format! This is also a bit of a pain for user to click ok everytime. If only I could change the size of the DV input message box!

 

[SaraWitch]

I have just spent an hour with MS technical support (to once again highlight shortcomings rather than for a solution!), and they advised that I open a discussion in MS Community as it might prompt much-needed change. I have done this, and hope that it doesn't break any MrExcel forum rules...