Hi,
I have a worksheet that contains pin numbers, these feed some comboboxes
with other data when a pin number is selected from a listbox. When I add a
new pin number to the worksheet and try to select the new pin from the
listbox I get the following error -

Runtime error '-2147952571(80020005)':Could not set the Value property 'Type
Mismatch

It appears that the new pin number is not recognised in the format entered,
I have checked the worksheet and interestingly all the older pin numbers
display an Excel green mark indicating the pin is stored as text. If I
change the new pin number to text format there is no change in the error
code.

Can anyone advise what may be happening please?
Thanks,
Mickey