I know I'm thick, but I just can't get the attached to work.
Its got a 2-column table, column A is named "Serial_No", and the whole table is named "Fix".
Click the button and a UserForm pops up with a ComboBox linked to Serial_No, and a TextBox in which I want to display the Tail Number associated with the Serial number picked from the ComboBox - "Piece of cake!" you all shout. You just set the TextBox.Value in the ComboBox Change() event, like this:
Private Sub cboSerialNo_Change()
txtTailNo.Value = WorksheetFunction.VLookup(cboSerialNo.Value, [Fix], 2, 0)
But that gives an error every time, either "unable to set VLookup property of WorksheetFunction class" if I specify the range name complete with sheet! name, or "Argument not optional" if I don't! :mad:
How the Sam Hill can I fix this?