TextBoxes and Data Filtering
Here is the code as it appears on my UserForm. The code stops at the
comment line "get the next visible cell down" and I get an Expect End Sub
error.
I suspect that I should be doing something else with the code below your
comment line but I do not know what.
Private Sub UserForm_Initialize()
Dim rng As Range
Set rng = Cells(ActiveCell.Row, 1)
TextBox1.Value = rng.Offset(0, 3).Value
TextBox2.Value = NextVisbleCellDown(rng).Offset(0, 3).Value
'Get the next visible cell down
Function NextVisbleCellDown(rng As Range) As Range
Dim rv As Range
Set rv = rng.Offset(1, 0)
Do While rv.Height = 0
Set rv = rv.Offset(1, 0)
Loop
Set NextVisbleCellDown = rv
End Function
End Sub
|