Hi I'm new here
First post. Thanks for reading it.
I'm trying to achieve the following but I'm stumped;
Each time the user clicks the cmdButton, the value of the next cell in the column is displayed in the TextBox.
(The user will eventually come across a value in the TextBox that he or she is looking for and select it)
Here is my non-working novice code;
Dim DriverName As String
Dim i As Integer
Dim c As Integer
Dim ws As Worksheet
Set ws = Worksheets("Incomplete")
i = 0
Do
i = i + 1
If ws.Cells(i, 2).Value <> "" Then
c = c + 1
End If
Loop Until ws.Cells(i, 2) = ""
For i = 2 To c
DriverName = ws.Cells(i, 4).Value
Next i
txtShowDriverName.Value = DriverName
Bookmarks