<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>I'm a baffled by how to monitor a ComboBox's usage. I have the
Text property of ComboBoxConnectChannel equal to 'Please Select
Channel' with its List property empty. I then fill the list as
follows: <br>
With ComboBoxConnectChannel<br>
.Clear<br>
.Add("BBC One")<br>
.Add("BBC Two")<br>
.Add("BBC Four")<br>
.Add("CBBC")<br>
.Add("CBeebies")<br>
.Add("BBC News")<br>
.Add("BBC Parliament")<br>
End With<br>
</p>
<p>I then want the user to select an item from the list (which is
displayed with the correct list of values as a popup) after the
user clicks on the arrow to the right of the textbox part of the
ComboBox) and have the textbox (part of the ComboBox) set equal to
the value of the selected item. At runtime, the user selects one
of the items from the popup but its value is <b>not </b>shown in
the text box part of the ComboBox:<br>
Public Sub ComboBoxConnectChannel_Change()<br>
sConnectChannel = Trim(ComboBoxConnectChannel.Text)<br>
Print "Channel=" & sConnectChannel<br>
End</p>
<p>So for example if the user has clicked on the arrow followed by
clicking on the 'BBC Four' item, the variable sConnectChannel is
set equal to 'BBC Four' correctly but the textbox part of the
ComboBox still shows 'Please Select Channel'. What do I change in
the above Public Sub coding to achieve this?<br>
</p>
</body>
</html>