TextBox12.Value = WorksheetFunction.VLookup(ComboBox7.Value, rng, 11,
0)
myRow = WorksheetFunction.Match(ComboBox7.Value, Range("D3:D3999"),
0)+2
Worksheets("Members").Cells(myRow, 11) = TextBox12.Value
since you start from row 3, you add 2 in the second line.
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=377601