Hi All,
I've searched here and googled but to no avail. I'm not to savvy on this VBA stuff but have fumbled around and created a Userform with a ComboBox and several other fields in an Excel Workbook. The ComboBox gets its list of Customer names from a range in a worskeet.
=OFFSET(Customers!$A$3,0,0,COUNTA(Customers!$A:$A),1)
What I would like to do is that if a name is not in the list that the user can add the name to the ComboBox by way of some sort of Subform that would pop up if they try to enter a name not in the list? This subform would then update the Range that the ComboBox uses and the user can choose the new name from the ComboBox and continue adding other data in the rest of the UserForm fields...help please...
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
I've searched here and googled but to no avail. I'm not to savvy on this VBA stuff but have fumbled around and created a Userform with a ComboBox and several other fields in an Excel Workbook. The ComboBox gets its list of Customer names from a range in a worskeet.
=OFFSET(Customers!$A$3,0,0,COUNTA(Customers!$A:$A),1)
What I would like to do is that if a name is not in the list that the user can add the name to the ComboBox by way of some sort of Subform that would pop up if they try to enter a name not in the list? This subform would then update the Range that the ComboBox uses and the user can choose the new name from the ComboBox and continue adding other data in the rest of the UserForm fields...help please...
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">