SORRY FOR THE MISTYPE.I MEANT VLOOKUP FORMULA THROUGH A MACRO

"sonto" wrote:

Is thre a way that you can do vlookup formula in a workbook in that it checks
for data from a hidden worksheet in a workbook.I have also created a userform
but after it hides I would want to be called when a buttun is clicked as when
the userform is displayed on the screen you can not edit the worksheet