| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
View values; ignore header database
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
View values; ignore header database
Problem solved:
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 +1, 5).Value "Gert-Jan" schreef in bericht ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't view Header Text | New Users to Excel | |||
| header and footer view | Excel Discussion (Misc queries) | |||
| View header | Excel Discussion (Misc queries) | |||
| How can I keep the header in view at all times | Excel Discussion (Misc queries) | |||
| how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
Linear Mode
