Retrieve cell data to a Form text box

[Stusouth]

Sorry if this has been asked before.

What I'm trying to achieve is this. Based on a Dropdown box in a Form, select a Sku reference. Based on this reference then pull into another text box the Sku Description which is saved in a cell within my worksheet. My Sku references are in "A" and Descriptions in "B".

I've got a separate form to be able to save down new Sku's and there descriptions, but drawing a complete black at retrieving data. can anyone help.

 

[RasGhul]

Hi Stu,

Assuming your Dropdown box & Textbox is Combobox1 & Textbox1

Maybe try

Dim totrows As Long, i As Long

'Userform Textbox update Description on Combobox1
totrows = Worksheets("Sheet1").Range("A2").CurrentRegion.Rows.Count

For i = 2 To totrows
    If Trim(Sheet1.Cells(i, 1)) = Trim(ComboBox1.Value) Then
       TextBox1.Text = Sheet1.Cells(i, 2)
       Exit For
    End If
Next i