help needed on userforms

[Johnwayne]

how do i create a combobox in userform that dependent on data in column"A" in sheet 1..
and once i select the data using combobox in userform, my textbox will show information in column B..depending on the row i select in combobox.
please advise

 

[Andrew Poulsom]

Use Insert|Name|Define to name the cells in column A eg List. Set the ComboBox's RowSource to List. Then use this code:

Private Sub ComboBox1_Change()
    TextBox1.Text = Range(ComboBox1.RowSource).Cells(ComboBox1.ListIndex + 1, 2).Value
End Sub

 

[Johnwayne]

futher problems

Ok, from there, how do I edit those textbox and save it back to my database.
As in, when I choose my item in combobox1, my texbox1 will return me a value, lets say “20. now I want to change it to 30 instead of 20. how do I edit it once I select my item in combobox1?
Besides this, how do I delete the entry by clicking a button using combobox1 to select the row that I want to delete?

Basically, I have 2 scenarios,
1) is to edit the data by selecting my item in combobox1
2) is to delete the data by selecting my item in combobox1