Mourning the loss of our friend, WhitPhil.
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
 
Software Development
Tag Cloud
access audio black screen blue screen bsod connection crash dell desktop drivers dvd email error excel excel 2003 firefox hard drive hardware hdmi hijackthis internet itunes keyboard laptop malware monitor motherboard network networking outlook problem ram recovery router screen slow sound spyware tdlwsp.dll trojan upgrade video virus vista vundo windows windows 7 windows vista windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Software Development >
VBA conditionally hide rows

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

 
Thread Tools
VanHelsing's Avatar
Junior Member with 5 posts.
 
Join Date: Nov 2009
Experience: Intermediate
04-Nov-2009, 05:42 AM #1
VBA conditionally hide rows
Hi,

I need a little help with a VBA code: when a radio button is clicked, then a number of rows on an other sheet are hidden. The rows which are hidden contain a certain text string.

Thank you in advance.
VanHelsing's Avatar
Junior Member with 5 posts.
 
Join Date: Nov 2009
Experience: Intermediate
09-Nov-2009, 04:42 AM #2
Hi,

Thank you for the reply.
Here's what I'm trying to do: I have a series of buttons on Sheet1 and a series of questions on Sheet2. If I press Button1 (named "John") on the first sheet then I'd like that all questions on the second sheet that contain the "John" reference to be hidden. The questions that contain the "John" reference are not contiguous, but are spread throughout the second sheet.
Could it be possible to hide the rows based on the keyword? For example: if I press the "John" button then the VBA macro searches and hides all rows that contain the "John" reference.

Thank you in advance.
Rollin_Again's Avatar
Distinguished Member with 3,728 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Brilliant When Sober
10-Nov-2009, 10:35 AM #3
Can you post a sample workbook?

Regards,
Rollin
VanHelsing's Avatar
Junior Member with 5 posts.
 
Join Date: Nov 2009
Experience: Intermediate
11-Nov-2009, 07:24 AM #4
Hi
Here's a sample of the workbook.

Thank you in advance.
Attached Files
File Type: xlsx test1.xlsx (28.0 KB, 11 views)
Reply Bookmark and Share

Smart Search

Find your solution!



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.

Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 02:19 PM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.
Powered by Cermak Technologies, Inc.