View values; ignore header database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Gert-Jan" <gjvanmiddelkoop@xxxxxxxxxx>
Date: Tue, 4 Jul 2006 15:45:48 +0200

In a database (Sheet3) I have values in some columns. In row 1 there are
headers. I created a userform to view al the values. How should the userform
ignore the first line; the headers are not very interesting...

Private Sub ComboBox1_Change()
If Range("Sheet3!A2") = "" Then
Exit Sub
Else
Sheets("Sheet3").Select
Dim i As Long 'Index
i = ComboBox1.ListIndex + 1
vrijwap = Cells(i, 5).Value
....
....
volgende.Enabled = i < ComboBox1.ListCount
vorige.Enabled = i > 1

.

Follow-Ups:
- Re: View values; ignore header database
  - From: Gert-Jan

Prev by Date: Modification to existing Code
Next by Date: Re: How to take a range input in a function and find the frequency of data in it.
Previous by thread: Modification to existing Code
Next by thread: Re: View values; ignore header database
Index(es):
- Date
- Thread