-
You wouldn't know of a way to autosize the content control's drop down list's width based on its contents would you?
It seems by default its a function of the currently selected item's width.
Only thing I've figured out so far isn't pretty. I can append a few spaces on the end of my shorter entries, so that all entries end up being the same length. but then I have to but a trim statement in the code when trying to use one of those selected range.texts. It happens to work with the data I presently have, but I can see some shortcomings with the approach if I had different data.
-
EDIT:
Found a better way...
It seems the width can be manipulated by changing the width an entry, so I modified the first entry to act as a placeholder.
[VBA]activedocument.SelectContentControlsByTag("panel").Item(1).DropdownListEntr ies.Item(1).Text = "Pick a Panel >"[/VBA]
-
Keith,
My middle name. Easy to remember. Pleased I could help. I am sure there is plenty that I could learn from you!!