1024 Character Limit Workaround

[Neomagus]

Hi,

I am trying to find a VB script that is similar to this one:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=421#instr

I love it, but I need one that does not prompt my users for row height and will run automatically on one cell only (the 53rd to be exact). Maybe one that runs when the cell has been exited from?

My boss is being a real pain about this issue :motz2: , so any help you can give on this is really appreciated, this forum is great!

Thanks,

Mason

[acw]

Mason

How about changing it in the following way. I've basically commented out the part that prompts, and made a default.


'The maximum permitted number of characters on a line. User-specified up to a limit of 256 characters/line
'If .Column <> col Then 'Use same value as last time if still working in same column
' lineIncr = Application.Min(InputBox(Prompt:="Please specify the desired column width (in characters)", _
' Title:="Long Text In Cell Utility", Default:=.ColumnWidth - 1), 256)
' col = .Column
' If StartPos < lineIncr Then StartPos = lineIncr
'End If
lineIncr = 256
If StartPos < lineIncr Then StartPos = lineIncr



HTH

Tony

[Neomagus]

Thank you for the help, That has fixed the prompt. Hmm, I still do not know to make it automatically run though. Also, it seems odd but now the row does not display in print preview or print the contents correctly. Any thoughts?:think: