LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default THIS IS A BUG

Object positioning is set to "Move but don't size with cells"

Uset this code to add checkboxes to a 25Rx4C selection of cells:

Sub SAM()
Dim c As Range
Dim lb As Shape

For Each c In Application.Selection
With ActiveWorkbook.ActiveSheet
Set lb = .Shapes.AddFormControl(xlCheckBox, c.Left + (c.Width / 3),
c.Top, 0, 12.75)
lb.TextFrame.Characters.Text = ""

lb.ControlFormat.LinkedCell = c.Address

End With
Next
End Sub

Try to insert single entire rows in the set of checkboxes. Randomly, a row
of check boxes will move with the inserted row. Next randomly, the checkboxes
will not move with the inserted row. This ain't right...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"