View Control of Form Controls

[John Jost]

In my Excel workbook, sheet1, I have added several option (radio) buttons
from the Forms Toolbar along with some frames and checkboxes. In cell B10,
and C10 I have two radio buttons, one is “Pre Sales†and the second is “Post
Salesâ€

If I select “Pre Sales†I will hide rows 50-100 which is the Post Sales
information. If I select “Post Sales†I will hide the “Pre Sales†rows
15-49. I can do this hide show, no problem by creating views, however, any
form objects, frames, checkboxes or radio buttons in these sections do not
hide, they always show.

How can I control the form objects using views, or hide/show?

 

[DM Unseen]

For each object:

left click,select Format Control, then Properties tab: select "Size and
move with cells"

DM Unseen

 

[chijanzen]

John:

TopLeftCell Property:Returns a Range object that represents the cell that
lies under the upper-left corner of the specified object

try,

Dim shp As Shape
For Each shp In Sheet1.Shapes
ss = shp.TopLeftCell.Row
If shp.TopLeftCell.Row > 15 And shp.TopLeftCell.Row < 49 Then
shp.Visible = msoFalse
End If
Next shp

 

[John Jost]

My "Size and Move with Cells" is greyed out? so far cant find the way to get
it back on. I'm using Excel 2003

 

[John Jost]

very interesting. I will give this a try

John:

TopLeftCell Property:Returns a Range object that represents the cell that
lies under the upper-left corner of the specified object

try,

Dim shp As Shape
For Each shp In Sheet1.Shapes
ss = shp.TopLeftCell.Row
If shp.TopLeftCell.Row > 15 And shp.TopLeftCell.Row < 49 Then
shp.Visible = msoFalse
End If
Next shp

--
天行å¥ï¼Œå›å­ä»¥è‡ªå¼·ä¸æ¯
地勢å¤ï¼Œå›å­ä»¥åŽšå¾·è¼‰ç‰©

http://www.vba.com.tw/plog/