ComboBox /Textbox data

[Marlon0180]

Hi guys,
Newbei here
need your help
I have this form, and i wanted to get data from my excel sheet and pick it to my droplist MO no.: the auto show other figures on my text box MO Qty. Sty no. Bal Qty.

here is my form


here is my excel



Hope you can help me

 

[Hui]

If the list is always the same size you can add it manually to the control
select the Combobox and edit the RowSource


If the list will change you can assign it to a Named Formula

where DataList is =OFFSET(Sheet1!$B$3,,,COUNTA(Sheet1!$B:$B),1)

otherwise you can programatically add data to the control

 

[Belleke]

Is this what you are looking for?
See attached.
I made an example this time.
Next time post a example of your workbook instead of pictures please.
Pictures are for a photoshop forum.