in sheet1, i have a table like this
activities date completed drawing jan.1,2013 painting jan.6,2013
(note:this table is downloaded from web,everytime the value on the web changes,the value in the excel spreadsheet also changes.)
then, i have a form . it is composed with a combo box and a textbox.
i was able to populate the combobox with the item on the activities column.
what i want is that whenever i click the drawing in the combobox, i want the textbox to display the date completed corresponding to this item which is "jan.1,2013".
i dont know what to do.im stuck in here.
here's my code:
Private Sub UserForm_Initialize()
'Populate Activities combo box.
Dim rngActivities As Range
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
For Each rngActivities In ws.Range("ActivitiesList")
please help me. i'm new in here. please. thank you in advance.