unable to get the vlookup property of the worksheet function class

**zak.horrocks** · 10-17-2014, 08:23 AM

Hello,

I have this code:

Please Login or Register  to view this content.

It works fine until I try to clear the combobox and textbox using:

Please Login or Register  to view this content.

I get the run time error '1004': Unable to get the VLookup property of the worksheetFunction class.

Any ideas?

Thanks

Z

**alansidman** · 10-17-2014, 08:27 AM

You need to include some error trapping in your code. Look at this link
http://www.cpearson.com/excel/Callin...ionsInVBA.aspx

**zak.horrocks** · 10-17-2014, 08:52 AM

I thought as much but I'm unsure over where/which error trap to include.

Z

**Norie** · 10-17-2014, 09:26 AM

All you need to do is add code to check if the textbox/combobox are empty.

Or you could use something like this.

Please Login or Register  to view this content.

**zak.horrocks** · 10-17-2014, 09:35 AM

That works perfect! Thanks Norie

Re: unable to get the vlookup property of the worksheet function class