I have a form where I use the combobox to select a row to edit.
The worksheet has a filter. Can I tell the combobox to only show the visible
rows? I don't want to loose the index in the combobox because I use the index
to update the cooresponding row.

Data Filter On
Visible Rows# Combo Box Value
1 Row1
2 Row2
4 Row4

Using the above example, if I select Row4 from the combo box, I want to
automatically update Row4, not Row3 --- How do I do that? I also want the
combo box values to show Row1, Row2, Row4 only since Row3 is hidden it should
not show up. If the user changes the data filter then the values displayed in
the combo box should automatically change.

Thank you!