The current result is 'Nothing' when I hover over the highlighted bit of code with the error.
Sheet9 is called Suppliers ....However, I did tried exchanging ("Sheet9") with ("Suppliers") and it came back with another Runtime Error of ' 448 - Named Argument not found'.
The range that the Combo value is trying to match to is on Sheet9.. Column A:A.
The names tried are in the list, although, as I said, the list is made via a formula, I didn't know if that was the reason why .................it's probably the the referencing of the sheet.
It's too early to be confussed
On a sub question for you Martin. ...My combo box is based on column AZ but it's always showing the blank rows first and I have to scroll up to get to the top of the list, which also then shows the header.
I'm trying to show the List in order from AZ2 onwards (It would be nice to have the header showing in the Combobox at the start to act as a bit of a prompt)
If you've go a moment, please can you see what's wrong
Private Sub ComboBox2_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
If Me.ComboBox2.MatchFound = False Then
If MsgBox("The Supplier entered is not on the list. Do you wish to add it?", _
vbYesNo, "New Supplier Detected") = vbYes Then
[Az65536].End(3)(2) = Me.ComboBox2.Text
Range([Az1], [Az65536].End(3)).Sort Key1:=Range("Az1"), _
Me.ComboBox2.List = Application.WorksheetFunction.Transpose _
Many thanks for your help
Edited by: Squire_King on 05.19.04.