Populate Userform Based on Combobox Selection

[DoriBeE]

PLEASE don't shoot me if this is a repost... Searched the threads and didn't get any hits back on this particular issue.

I have a Userform which I've managed to get to Populate my worksheet perfectly... i was also able to get it to repopulate back onto the userform for editing. (the sheet is protected, any entry or edit must be done Via the Userform).

Ok

Issue:
Instead of using a "next" and "previous" button to get the form to read down the list of entries on the work sheet...

this is pretty much the code i used:
Private Sub cmdNext_Click()
'increment row number:
lCurrentRow = lCurrentRow + 1

'POPULATE FORM FIELDS
cmbRecords.Text = Cells(lCurrentRow, 7).Value
​

End Sub

(there are other fields but this explains my process i hope?...)
So yea, rather than using the next button to go through the records, i added a combobox to the form... the source is the name Column of the data sheet... i ranged it from g1 to g149 so anything that populates that range will pop up in the cmbox.)

Is it possible to, rather than selecting the "next" button to get through a 100+ records, for the user to just go to the combobox and select the record there? i guess i just need help in telling excel how to dentify the row?

I'm using lCurrentrow = 3 to start since all the data starts at row 3.

If i didnt provide enough info, or my question sounds completely ridiculous, let me know and i'll try to ask differently -_-*.

I just want the fields to populate the record information based on which record they select from the combobox ...

 

[BrianB]

Perhaps my code here might help.
There is an additional message to add a "Find" button.
Could use combo value as input.

http://www.mrexcel.com/board2/viewtopic.php?t=272831