View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Could not set the Text property of a ComboBox on User Form.

What is combo box's .Style set to ?
If it is 2-List, change to 0-Combo.

NickhK

"??????? ?. ???????" wrote in message
...
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.