View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default How Do I Load A ComboBox On A UserForm

Greetings,

I have a ComboBox (CBX1) on a UserForm (UF1) that needs to be loaded
from a named range (CustNames) on my spreadsheet.

I have CBX1, but I am not sure of the best way to load it. One
consideration is that sometimes there will not be a match in the
"CustNames" list for the name I need to enter, so I will need to enter
the name manually, directly into the ComboBox and if possible, have
VBA add that name into the "CustNames" list.

Is this possible? Any help would be appreciated.

TIA

-Minitman