Hi,
Thanks for your help.I tried to determine the exact length. Here are
my observations:
1. The AlternativeText is limited to 255 characters via the user
interface. You can view / edit only the first 255 characters.
2. I was able to enter at least 4096 characters in AlternativeText via
VBA. I tested it with the following code. This seems to be a fair
amount of space for me for all pratical purposes.

Thanks Mr. Pearson

Dim MetaString As String

MetaString = ""
For i = 1 To 4095
MetaString = MetaString & "A"
ActiveSheet.Shapes("Box").AlternativeText = MetaString
Next i
MetaString = MetaString & "B"
ActiveSheet.Shapes("Box").AlternativeText = MetaString

Debug.Print Len(ActiveSheet.Shapes("Box").AlternativeText)
Debug.Print Right((ActiveSheet.Shapes("Box").AlternativeText), 1)



On Oct 27, 2:39 pm, "Chip Pearson" wrote:
Is it limited to only 256 characters or something ?

AlternativeText length is limited to 4095 characters in Excel 2003. It seems
to be unlimited in Excel 2007 (I broke out of the loop at 64K characters and
it was still going strong).

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consultingwww.cpearson.com
(email on the web site)

"MutatedBrain" wrote in message

ps.com...

Thank you Mr. Pearson. Is there any limitations on alternative text ?
Is it limited to only 256 characters or something ?