View Control of Form Controls
 

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?

View Control of Form Controls
 

For each object:

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

DM Unseen

View Control of Form Controls
 

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/


"John Jost" wrote:

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?

View Control of Form Controls
 

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

"DM Unseen" wrote:

For each object:

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

DM Unseen

View Control of Form Controls
 

very interesting. I will give this a try

"chijanzen" wrote:

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/


"John Jost" wrote:

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?