check box linked cell
The address looks like E99 (no sheet is included).
Try:
chk.LinkedCell = Sheets("Estimates DB").Range("estdbcboxlnkcell") _
.Offset(estnum, 0).Address(external:=true)
ranswert wrote:
I am trying to link a checkbox to a cell on a different sheet than the
checkbox is in. This is the code I am using:
chk.LinkedCell = Sheets("Estimates
DB").Range("estdbcboxlnkcell").Offset(estnum, 0).Address
When I run it, the checkbox is being linked to a cell on the sheet that the
checkbox is in.
What am I doing wrong?
Thanks
--
Dave Peterson
|