UserForm of Autotext Entries

ptmuldoon · #9 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Userform calls other userform, then populate worksheet	Lehoi	Excel Programming	0	02-03-2016 02:58 PM
VBA Code in a UserForm module to delete a Command Button which opens the userform	Simoninparis	Word VBA	2	09-21-2014 03:50 AM
Is it possible to take an input from a UserForm in one document to a UserForm in a do	BoringDavid	Word VBA	5	05-09-2014 09:08 AM
Using Word autocorrect and autotext entries in outlook	dswapp	Outlook	2	11-24-2010 10:18 AM
Maintaining AUtotext Entries from an external table.	kelzud	Word Tables	0	07-28-2009 01:31 PM