John Bundy
12/11/2006 11:58:00 PM
Works fine for me, since you didn't post the actual code I can only guess,
you probably need to put the userforname in there eg
userform1.combobox1.text="123"
if you don't do that then it looks for a combobox on the sheet containing
your code, if one is not there you get a run-time error.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"Ð?миÑ?Ñ?ий Ð?. Ð?обÑков" wrote:
> The statement
> ComboBox1.Text = "1,2,3"
> yields to a run-time error. The ComboBox1.MatchEntry is fmMatchEntryNone,
> and ComboBox1.MatchRequired is False . The "1,2,3" does not match any entry
> in the ComboBox1 at the time, but I want to show it in the edit field of the
> combo box.