I am using '97 and I can't seem to return the value of the checkbox. x = Sheets("New Report").textbox1.Value