View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jamescox[_106_] jamescox[_106_] is offline
external usenet poster
 
Posts: 1
Default Make option button link permanent to cell


I'm not sure (and I'm not able to test this just now) but the problem
may be that the linked cell is being assigned as an absolute reference
and any row or column insertions or deletions you are making may be
causing problems.

To test this, you can try making the following change:

LinkedCell = .GroupBox.TopLeftCell.Address(0,0)

This change will give instead of an absolute reference ($R$4) a
relative one (R4) - which might work better - or maybe not :(

Good luck with this!


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121855