Microsoft Office Forums - View Single Post

ptmuldoon · 02-12-2016, 01:03 PM

Quote:

Originally Posted by gmaxey

It appears that a list/combobox column limit is 2047 characters. Why are you trying to but the Value of an autotext in a combobox anyway?

Well, my initial thought/logic was in creating a userform that that listed specific Autotext entry's, and the user could then chose the one they want from the form and insert the autotext into body of a document.

I guess I could rework the code to only include a Name of the Autotext item as the combobox value. And use the command button code to query the result and post that full autotext?

I'll be boarding a plane soon, so hope to do some experimenting while traveling later today. I forgot how much fun this stuff could be

EDIT.

I just tried this in a command button, but seems the text being added to the document was still truncated?

Code:

For lngIndex = 1 To objTemplate.BuildingBlockEntries.Count
    Set oBuildingBlock = objTemplate.BuildingBlockEntries.Item(lngIndex)
    If oBuildingBlock.Name = ComboBox2.Text Then
      Selection.TypeText oBuildingBlock.Value
    End If
  Next lngIndex