View Control of Form Controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
For each object:

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

DM Unseen
 
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
 
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
 
very interesting. I will give this a try

chijanzen said:
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/
Click to expand...
 
Back
Top