View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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