Forum Discussion
Solved
how to use VB to change the size of input message box when use validation?
how to use VB to change the size of input message box when use validation? Use VB code to change the yellow box size, how to solve it?
- You cannot control the size of that box I'm afraid. You could consider a solution like this?
https://jkp-ads.com/articles/exceldataentrywithvalidationhelp.asp
I'm afraid you cannot change the size of that box using VBA, at least, not easily. Maybe with some (difficult) Windows API functions but I think that might be overkill.
What exactly are you trying to achieve?
What exactly are you trying to achieve?
I just want to display the input message in one line, not three. JKPieterse
- You cannot control the size of that box I'm afraid. You could consider a solution like this?
https://jkp-ads.com/articles/exceldataentrywithvalidationhelp.asp
