I'm trying to use the AfterUpdate event for a combobox to update a text
box, in the same userform.

Something like this:

Private Sub comboChooseColumn_AfterUpdate()
    If Me.comboChooseColumn.Text = "Column 1" Then
        Me.txtNoFields.Text = Range("NoFields1").Text
    Else
        Me.txtNoFields.Text = Range("NoFields2").Text
    End If
End Sub

The combobox contains two values, and the user is to specify one. While
still in the userform, the textbox (locked) must be updated with the
appropriate value, automatically.

But it does not work.

Anyone have any ideas as how to solve my problem?

Regards

Martin

Sent via Deja.com
http://www.*-*-*.com/

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup