View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dkline Dkline is offline
external usenet poster
 
Posts: 75
Default Filling a ComboBox range on focus

I have a combobox in which the end user wants to add new items from time to
time. I cannot figure out how to fill the ListFillRange from a macro.

On the sheet the control in the formula bar is EMBED("Forms.ComboBox.1","").

In the Name Box it is named as "cmbFinCarrier".

Right now the range is AJ6:AJ41.

I've tried to figure out how to just change the range in the properties.
I've tried the AddItem method. I can't get anything to work.

What do I need to do?