Hiding and Unhiding row Macro help

[misula29]

First off, im a new-B at VBS.... I have a spreadsheet with two section, only one of the sections is unhidden at a time based on the user clicking on 1 of 2 option buttons.... I recorded and assigned a macro to do this function and it works beautifully... my problem is a little more complicated...

In each of the two sections there is a question for the user and a listing combo box for the user to select an option. If a user is to select a option button,(unhidding or hidding the corresponding section) and select an option in the drop down combobox, THEN select the other option button the macro bombs

I think i need some VBS language to clear the comboboxes before the rows are hidden but i cant figure it out.... this is what the VSB is for the macros i have already done....

Sub NoClaims2()
'
' NoClaims2 Macro
'
'
Rows("75:79").Select
Selection.EntireRow.Hidden = False
Rows("79:85").Select
Selection.EntireRow.Hidden = True
End Sub
Sub WithClaims2()
'
' WithClaims2 Macro
'
'
Rows("78:87").Select
Selection.EntireRow.Hidden = False
Rows("76:78").Select
Selection.EntireRow.Hidden = True
End Sub

 

[jbeaucaire]

Not sure about what is crashing your macro, but the syntax on your macros can be tighted up. There's no need to select rows before hiding them.

Sub NoClaims2()
    Rows("75:79").EntireRow.Hidden = False
    Rows("79:85").EntireRow.Hidden = True
End Sub

Sub WithClaims2()
    Rows("78:87").EntireRow.Hidden = False
    Rows("76:78").EntireRow.Hidden = True
End Sub

But you do see how the rows overlap? You are using 79 in both the false and the true portions...