| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
| ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
| Unable to see Properties in Design View for controls | Excel Worksheet Functions | |||
| Control Toolbox Controls | Excel Programming | |||
| Controls Toolbox control vs Form Toolbox control | Excel Programming | |||
Threaded Mode
