Thanks Greg

That info and your other one on modifying the Ribbon has me rethinking my overall approach. But with the current userform approach, I just noticed a strange behaviour in that the Combobox2.value is being truncated and not getting the full amount of the autotext entry? The Combobox2 Maxlength is currently set for 0 which I think means unlimited? I tried to change that to 50000 as well but it had no effect.

Any thoughts on why the value would be trunacated?