Clear form that has vlookup function

[oshayne]

I am trying to clear a form (reset) with one of the text box has a vlookup value.
what code would i need to accomplish this .

[RGrunden]

Sounds like this could solve your problem

Please Login or Register  to view this content.

[oshayne]

thank you
but i am receiving a compile error "method or data member not found" on the '.clear'