255 Character Limit when using Excel 2007 Input Message

Hi,

I am wondering if anyone can help?

I have created a Change Calendar which uses VBA to pull through Change names which appear when you click on the week:

Change Calendar.JPG

The code is working, problem is the 255 character limit in the input message box, is there anyway this limit can be removed or extended?

Please Login or Register  to view this content.

Hi, Nic31,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger

HI,

I dont think there is to be honest with you.

YOu could bypass it and do it yourself, so if intersect(target,Target.Worksheet.UsedRange.SpecialCells(xlCellTypeAllValidation)) to tell you if it has validation.
Then handle the rest using a normal message box and logic.

I've written some custom validation using event sinking before now, you can tdo this in Excel 2010 using the worksheet_change event to do so.


Event sinking (older versions) would be something like

In a class, then on workbook open pass each sheet to the class....

Please Login or Register  to view this content.

Using this event is probably a good place to put it.

Please Login or Register  to view this content.