Vlookup VBA Error

[perrymagic]

Hello

i have a userform which has a combo box called "GoldCB", a text box called "Tbbranch" and a text box called "tbpost". the below code populates the "tbbranch" with whatever is chosen in "Goldcb" and then the vlookup code looks up the tbbranch value in a named range"goldtarget" and gives me the post code and populates "tbpost".

thw code works fine however whenever i clear the userform i get the following error Run-time error '-2147352571 (80020005)':
Clould not set the Value Property. type mismatch. if i then debug it highlights vlookup code below in yellow.

Please Login or Register  to view this content.

help is greatly appreciated.

Matt

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[Firefly2012]

You could simply ignore this error eg:

Please Login or Register  to view this content.

which will probably work fine. Alternatively, you would need to construct a way in which the code is not executed if the userform is cleared.

[perrymagic]

blimey something so simple but has taken me ages!!

thanks very much. perfect!!