User form hides wrong information

Use this as a guide on how to select the rows -

Sub x()
Sheets(2).Rows(3).Offset(1, 0).Hidden = True
End Sub

You can replace Sheets(2) with Sheets("Sheet2")

Thanks for the tip, but I am still getting the same problem. It hides the wrong rows and still hides rows even when nothing is selected.

When I tried to make an example to post, I couldn't get it to work at all. Still working on it so that you can see exactly what I am talking about.

Originally Posted by EGR2317

Thanks for the tip, but I am still getting the same problem. It hides the wrong rows and still hides rows even when nothing is selected.

When I tried to make an example to post, I couldn't get it to work at all. Still working on it so that you can see exactly what I am talking about.

Try something like -

Private Sub Ok_Click()
If chkOption1.value = True Then
Sheets(2).Rows(3).Offset(1, 0).Hidden = True
ElseIf chkOption2.value = True Then
Sheets(2).Rows(5).Offset(1, 0).Hidden = True
End If
End Sub

The VBA is not built to "select" anything. Most of these functions you will want to execute without physically selecting a cell or group of cells. If you want to change the active sheet then you can do so, but there was no need to select rows 3 and 4 by highlighting them.

Can you give me an example of multiple options being true?

You can write

If chkOption1.value = True AND chkOption2.value = True Then
...Code...
Else:
End if

The user form I am making is going to ask the user which options are omitted from the given sheet it will point to. If more than one option is omitted, then all rows corresponding to all omitted options would need to be hidden. Would I need to do something like:

If chkOption1 = True Then
     Sheets(2).Rows(3).Offset(1, 0).Hidden = True
ElseIf chkOption2 = True Then
     Sheets(2).Rows(3).Offset(1, 0).Hidden = True
ElseIf chkOption1 = True And chkOption2 = True Then
     Sheets(2).Rows(3).Offset(3, 0).Hidden = True
End If

And when I use the term "select" I mean that the desired rows are not being hidden. I used my original means of selecting because it matched the way VBA hid rows when recording a macro to do the same thing. Now, even when I write it the same way it would be written in a macro, the rows are not being hidden like they are supposed to be.

Thank you very much for all of the time you are putting into helping me in this matter.

Ok - try this first -

Get rid of all the "chk" prefixes in your code. You have them labeled "appearance" not "chkappearance" that should help. (do this for all of them)

That worked. Thank you very much. I should have noticed that the names were different.

One more thing. Is there a way to link my two user forms? When the user exits out of the OmitInfo box by choosing "Yes", I would like for it to take them straight into the other box.

Disregard the last post. I referenced the wrong name in the first box which is why it would not link

Sure -

Sub chkYes_Click()
If chkYes = True Then 
Private Sub CommandButton1_Click()
 UserForm2.Hide
 UserForm1.Show
Else: End
End IF
End Sub

Thanks for all of your help. You have made this task a lot earier on me.

Not a problem, Glad I could help.