Thanks to Patrick Molloy for responding to a previous post, my version of
Excel 2002 with SP3 is responding differently than his version of the same.
Maybe someone can try this and experience the same error and help me correct
a setting, property, option or whatever it takes to solve this error.
Try this example and see if you get the same error:
Open a new workbook and enter the lower case words "ned, jed, bed, ted" in
Open the Visual Basic Editor and add a UserForm. On the UserForm place two
comboboxes. Enter the following code:
Private Sub ComboBox1_Change()
Sheets("Sheet1").Range("$A$2") = ComboBox1.Value
Private Sub UserForm_initialize()
ComboBox1.ControlSource = "Sheet1!$A$1"
ComboBox1.RowSource = "Sheet1!$A$3:$A$6"
Run the UserForm and select "ned" in ComboBox1 and tab to the other control.
Go back to ComboBox1 and highlight only the letter "n" in "ned" and change
it to the letter "j". Tab to the other control. In my Excel 2002 SP 3, the
value of the ComboBox does not change. If I select the single letter "j" that
appears in the combobox and change it to "d" the value will now change.
In summary, using this example, if I select only the first letter of the
word in the combobox and change only that first letter to one of the other
first letters of the words in the RowSource, the value of the combobox will
only change on every other change attempt. If I change only the first letter
of the word in the combobox to a letter that does not appear in the
RowSource, "r" forinstance, the combo box value will change on the first try.
Strange but true ... any
help would be great.