[SOLVED] Hide subsequent rows based on pull down list choice - macro


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

 
 
Thread Tools Rate Thread Display Modes
  #1  
Old 11th May 2010, 21:15
SoilSaver's Avatar
SoilSaver
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Hide subsequent rows based on pull down list choice - macro
     Excel: VBA   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: VBA   

I have a spreadsheet that has 9 resource concerns listed. Next to each
concern is a cell with a drop down list (data validation list) where the user
can choose high, medium or low. Below each resource concern are rows that
have questions associated to the concern that they need to answer if they
choose high or medium.

I need a macro that will unhide the rows below the each concern if high or
medium is chosen in the drop down list, but keep the rows hidden if the user
chooses low. It needs to update each time the list is pulled down, so that
if they initially choose low, but come back later and chage it to medium, the
rows will then unhide to show the questions.

Very new at macros, so any help is appreciated. If it is easier to use
something other than a data validaiton list for the choices, I am open to
changing it.



The Code Cage Advertisment
Advertisement
  #2  
Old 12th May 2010, 04:32
stanleydgromjr's Avatar
stanleydgromjr stanleydgromjr is offline
Junior Member
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient at manipulating data
 
Join Date: Jul 2009
Location: Northeast Pennsylvania, USA
Posts: 56
Posts Per Day: 0.02
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 32 (9) stanleydgromjr is on a distinguished road
USA
Default Re: Hide subsequent rows based on pull down list choice - macro

------ Register to get rid of these "In Post" ads! ------


SoilSaver,

Please post your workbook/worksheet.

Click on New Reply, then scroll down and see Manage attachments.



  #3  
Old 12th May 2010, 16:11
SoilSaver's Avatar
SoilSaver
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Hide subsequent rows based on pull down list choice - macro

------ Register to get rid of these "In Post" ads! ------


I can't figure out how to do the attachment. I don't see *New Reply*, just
Reply, and there is not option for attachments that I can see. Here is a
sample of what I am doing:

Cell A1 has pull down with High, Medium, Low or "blank" choices

If user chooses High or Medium, rows 2,3,4,5 need to unhide.
If user chooses Low or if the cell is blank, rows 2,3,4,5 need to hide.

I want this to work anytime a change is made. I need to repeat this
function for each of the 9 pull down lists.

Thanks!


"stanleydgromjr" wrote:

>
> SoilSaver,
>
> Please post your workbook/worksheet.
>
> Click on *New Reply*, then scroll down and see Manage attachments.
>
>
> --
> stanleydgromjr
> ------------------------------------------------------------------------
> stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?u=503
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=202064
>
> http://www.thecodecage.com/forumz
>
> .
>




The Code Cage Advertisment
Advertisement
  #4  
Old 13th May 2010, 00:56
stanleydgromjr's Avatar
stanleydgromjr stanleydgromjr is offline
Junior Member
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient at manipulating data
 
Join Date: Jul 2009
Location: Northeast Pennsylvania, USA
Posts: 56
Posts Per Day: 0.02
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 32 (9) stanleydgromjr is on a distinguished road
USA
Default Re: Hide subsequent rows based on pull down list choice - macro

------ Register to get rid of these "In Post" ads! ------


SoilSaver,

Please post your workbook/worksheet.

Click on Reply, then scroll down and see Manage Attachments.



The Code Cage Advertisment
Advertisement
 
The Code Cage at Facebookhe Code Cage at Twitter


Tags
based, choice, hide, list, macro, pull, rows, subsequent

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 05:35.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University
X vBulletin 3.8.7 Debug Information
  • Page Generation 0.17435 seconds
  • Memory Usage 6,355KB
  • Queries Executed 19 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footerEnd
  • (1)ad_footerStart
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_headerEnd
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_leftcolumn_code
  • (1)ad_navbar_below
  • (3)ad_postbit_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (4)helpful_answers
  • (1)helpfulanswers_javascript
  • (1)navbar
  • (3)navbar_link
  • (3)navbar_noticebit
  • (52)option
  • (4)post_thanks_box
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_ctoptip
  • (2)postbit_onlinestatus
  • (2)postbit_reputation
  • (4)postbit_wrapper
  • (1)showthread_changepostsowner_link
  • (1)showthread_extra_fields
  • (1)showthread_quickreply_mrgdp
  • (1)showthread_reason_popup
  • (1)spacer_close
  • (1)spacer_open
  • (1)su_form
  • (8)tagbit
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_datastore.php
  • ./includes/class_hook.php
  • ./awcoding/plugins/awc.php
  • ./awcoding/plugins/ds.php
  • ./awcoding/plugins/ss.php
  • ./includes/functions_notice.php
  • ./mobiquo/smartbanner.php
  • ./mobiquo/include/classTTConnection.php
  • ./mobiquo/smartbanner/head.inc.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/vbatags.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php
  • ./includes/functions_misc.php
  • ./includes/functions_prefix.php 

Hooks Called:
  • init_startup
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_check_criteria
  • notices_noticebit
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • helpfulanswers_showthreadorpost
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • helpfulanswers_show_normal
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • error_fetch
  • reputation_power
  • reputation_image
  • postbit_imicons
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete