I am trying to write a formula to use Vlookup and I want to use TextBox 8 as the Workbook to pull it from. I am not able to do that though it appears.
Can someone tell me what another way to write this is?



Range("B3").Formula = " =VLOOKUP($A3 [ " TextBox8.Value & .Xls"]Notes!$A$50:$H$81,7,False) "

Thanks in advance.