Data Validation Input Message Box Size

%3CLINGO-SUB%20id%3D%22lingo-sub-2261483%22%20slang%3D%22en-US%22%3EData%20Validation%20Input%20Message%20Box%20Size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261483%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20realise%20there's%20not%20a%20solution%20to%20this%2C%20but%20I%20have%20just%20spent%20an%20hour%20with%20MS%20technical%20support%20who%20advised%20I%20start%20a%20discussion%20as%20there%20may%20be%20more%20chance%20that%20MS%20will%20pick%20this%20up%20and%20make%20much-needed%20changes!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegardless%20whether%20you%20are%20within%20the%20DV%20Input%20Message%20character%20limit%2C%20the%20'view'%20box%20on%20the%20sheet%20does%20not%20show%20a%20good%20chunk%20of%20text%20at%20the%20end%20(if%20you%20have%20used%20text%20up%20to%2C%20but%20not%20over%2C%20the%20limit).%26nbsp%3B%20For%20example%2C%20I%20have%20a%20DV%20DDL%20with%20the%20first%20letters%20of%20actions%20(i.e.%2C%20A%2C%20DC%2C%20D%2C%20etc.).%26nbsp%3B%20I%20then%20have%20a%20DV%20Input%20Message%20box%20for%20the%20Key%2C%20i.e.%3A%3C%2FP%3E%3CP%3E%3CEM%3E%26nbsp%3B%20%26nbsp%3BTitle%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Key%3A%3C%2FP%3E%3CP%3E%3CEM%3E%26nbsp%3B%20%26nbsp%3BInput%20message%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20A%20%3D%20Away%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20DC%20%3D%20Daily%20Call%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20D%20%3D%20Disclaimer%3C%2FP%3E%3CP%3Eetc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%2014%20actions%2C%20and%20the%20bottom%20three%20are%20not%20showing%20on%20the%20DV%20input%20message.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20cannot%20resize%20the%20box.%26nbsp%3B%20You%20cannot%20change%20the%20format%20in%20DV.%26nbsp%3B%20You%20cannot%20do%20anything%20to%20make%20visible%20the%20missing%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVery%2C%20very%20annoying%3B%20and%20I%20know%20I'm%20not%20alone%20who%20finds%20this%20frustrating!%26nbsp%3B%20Please%2C%20please%2C%20please%20MS%20-%20sort%20it%20out!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20now%20having%20to%20use%20a%20workaround%20that%20I%20didn't%20want!%26nbsp%3B%20Thanks%20Microsoft.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2261483%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Good afternoon.

 

I realise there's not a solution to this, but I have just spent an hour with MS technical support who advised I start a discussion as there may be more chance that MS will pick this up and make much-needed changes!

 

Regardless whether you are within the DV Input Message character limit, the 'view' box on the sheet does not show a good chunk of text at the end (if you have used text up to, but not over, the limit).  For example, I have a DV DDL with the first letters of actions (i.e., A, DC, D, etc.).  I then have a DV Input Message box for the Key, i.e.:

   Title

      Key:

   Input message

      A = Away

      DC = Daily Call

      D = Disclaimer

etc.

 

I have 14 actions, and the bottom three are not showing on the DV input message.

 

You cannot resize the box.  You cannot change the format in DV.  You cannot do anything to make visible the missing text.

 

Very, very annoying; and I know I'm not alone who finds this frustrating!  Please, please, please MS - sort it out!

 

I am now having to use a workaround that I didn't want!  Thanks Microsoft.

 

p.s. it would also be really handy to increase the character limit!

 

2 Replies

@SaraWitch 

Unfortunately, I cannot infer from your text what exactly is being searched for. In this case,

the translation is probably more of an obstacle than an aid.

With your permission, I would like to recommend that you insert a file (without sensitive data),

explain your project / topic / problem on the basis of this file, as detailed as possible.

So you can be sure that you will get the best possible solution.

At the same time it is a great help for everyone who wants to help.

Knowing the Excel version and the operating system would be of great benefit ... for you:).

Helpers are there to help, you have to swing the project yourself.

Read the first Post in this Forum: Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

 

@SaraWitch 

That's better to publish on excel.uservoice.com. Perhaps something similar already exists, I didn't check.