this is the code im trying to use

if me.namebox.Value = sheet3.Cell.b1 then me.brix.Value = range.("brix")

cheers