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: 1
Default Combo Box & Unhide Rows


I have a survey template created by another that I am modifying for my use. The template includes dropdown boxes for secondary questions based on responses to primary questions. The code instructs Excel to hide rows & set visible properties of the dropdown boxes in those rows to false. If the user goes back and answers a question with a secondary response, the rows reappear as programmed, but the combo boxes will stack up below the original selection. Here is a sample of the code used:

If Sheets("parameters").Range("acty_d1_value").Value = 0 Then
'hide drop down boxes
ActiveSheet.cbx_a1d1.Visible = False
ActiveSheet.cbx_a1d2.Visible = False
ActiveSheet.cbx_a1d3.Visible = False
'Black out the activity name and total
ActiveSheet.Range("get_info_detl_a1").Select
Selection.RowHeight = 0
ActiveSheet.Range("a1").Select


Else
'unhide drop down boxes
ActiveSheet.cbx_a1d1.Visible = True
ActiveSheet.cbx_a1d2.Visible = True
ActiveSheet.cbx_a1d3.Visible = True
'make rowheight 45
ActiveSheet.Range("get_info_detl_a1").Select
Selection.RowHeight = 25
ActiveSheet.Range("a1").Select


get_info_detl_a1 refers to teh entire range of the questions & dropdowns for the A1 series; the cbx references are the names I gave the combo boxes.

Any suggestions?
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enabling option „Format rows“ to hide/unhide rows using VBA-code? ran58 Excel Discussion (Misc queries) 0 July 28th 09 03:46 PM
Can't unhide rows Bob Flanagan[_2_] Excel Discussion (Misc queries) 4 January 27th 09 12:48 AM
Unhide rows 1 - 9 W Wolfe[_3_] Excel Discussion (Misc queries) 3 July 13th 08 10:42 PM
unhide row does not unhide the hidden rows nikita Excel Worksheet Functions 4 May 24th 08 02:59 PM
unhide rows Wanna Learn Excel Discussion (Misc queries) 12 April 10th 07 02:16 PM


All times are GMT +1. The time now is 04:55 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"