Neville Bentley
Board Regular
- Joined
- Oct 3, 2007
- Messages
- 101
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
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