1.) Private Sub CommandButton3_click()
BeginRow = 10
EndRow = 37
ChkCol = 5
For RowCnt = BeginRow To EndRow
If Cells(RowCnt, ChkCol).Value = "Not Applicable" Then
Cells(RowCnt, ChkCol).EntireRow.Hidden = True
Cells(RowCnt, ChkCol).EntireRow.Hidden = False
2.) I have a command button on the spreadsheet that states refresh data.
3.)=INDEX(Material_Numbers,Sheet1!V2), I am creating a selection sheet where the user will identify parts requirements for different parts of their system. In this case I am asking the user how may of a type of material they need, then the user identifys the model they need. Once the selection is made the spreadsheet with the above code is making a Bill of Materials based on the Models that have been chosen. I have 8 list boxes for 1 section but if the user only needs 2 I don't want to show 6 extra rows that the part number is not applicable.
4.) When I click the refresh data button it appears that the macro runs and reviews the data but nothing changes.
5.) The real value is Not Applicable