Question:
does the code below(txtCode is the name of my combobox, strRowSource is the address of the Data in a column) stores the data in the combobox???
The code:
With UserForm1.txtCode
'Clear old ListBox RowSource
.RowSource = vbNullString
'Parse new one
.RowSource = strRowSource4
'.AddItem = strRowSource
End With
Because when I chack the value with
msgbox userform1.txtCode.Value
it returns nothing
Can someone please help me out
Thanks in advance
does the code below(txtCode is the name of my combobox, strRowSource is the address of the Data in a column) stores the data in the combobox???
The code:
With UserForm1.txtCode
'Clear old ListBox RowSource
.RowSource = vbNullString
'Parse new one
.RowSource = strRowSource4
'.AddItem = strRowSource
End With
Because when I chack the value with
msgbox userform1.txtCode.Value
it returns nothing
Can someone please help me out
Thanks in advance