scottmcclean
New Member
- Joined
- Jul 2, 2014
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi all,
I would like some help please in being able to hide rows based on a combobox selection.
I have a sheet that contains a lot of rows an would like the user to be able to filter out rows depending on what they select from a combobox. I am new to VBA and have looked at some examples on the net but none seem to do what I would like.
Here is an example:
The combobox is called combobox 1 which sits on the same sheet as the data (sheet1). This holds a number of values. These values correspond to vales that could be anywhere within each row. Most though are in column B. If there is a solution to finding the value anywhere in the row then excellent, if not I could just try and put all the values in one column. Whatever the user selects from the drop down I would like the rows with that value in to be hidden, for instance "473".
Any help gratefully received!
<tbody>
</tbody>
I would like some help please in being able to hide rows based on a combobox selection.
I have a sheet that contains a lot of rows an would like the user to be able to filter out rows depending on what they select from a combobox. I am new to VBA and have looked at some examples on the net but none seem to do what I would like.
Here is an example:
The combobox is called combobox 1 which sits on the same sheet as the data (sheet1). This holds a number of values. These values correspond to vales that could be anywhere within each row. Most though are in column B. If there is a solution to finding the value anywhere in the row then excellent, if not I could just try and put all the values in one column. Whatever the user selects from the drop down I would like the rows with that value in to be hidden, for instance "473".
Any help gratefully received!
A | B | C | <tbody> </tbody> | ||
row 1 | 473 | This is data for 473 | Hide this row | ||
row 2 | 998 | relates to 473 | Hide this row | ||
row 3 | 356 | This is data for 356 | |||
row 4 | 473 | This is data for 473 | Hide this row | ||
row 5 | 473 | This is data for 473 | Hide this row | ||
row 6 | 298 | This is data for 298 | |||
row 7 | 298 | This is data for 298 |
<tbody>
</tbody>