A Lookup in a text box In a User form

[Neville Bentley]

Morning Out there,

I have a userform that has a couple of text boxes that I plan to have formulas in and one of them needs to reference a 'Rates sheet' and do a VLOOKUP. How do I get this formula

"=VLOOKUP(I21,'[Vol_LCM Calculator_v1 05.xls]CbM3_Value'!$A$2:$C$36,3,FALSE)/I19"

(which works on the spreadsheet) to work in the userform?

Any Ideas?

Cheers

Neville

 

[Andrew Poulsom]

You could put the formula in a cell and assign the value of that cell to your text box. Alternatively:

TextBox1.Text = Evaluate("=VLOOKUP(I21,'[Vol_LCM Calculator_v1 05.xls]CbM3_Value'!$A$2:$C$36,3,FALSE)/I19")

will work, provided that the worksheet that would contain the formula is the ActiveSheet.

 

[Neville Bentley]

Thanks Andrew,

I will give it a go. Could I do the same with other Text boxes?

Cheers

Neville

 

[Andrew Poulsom]

If it works for one TextBox it will work for others.