View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 4
Default Dynamic update on ComboBox

I created a list of item B2:B22 in a page called "Notes" and then linked a
Combobox from page1 to that list of items.
that works great, but I want the list to be Dynamic, so when I add an item
to the item list it would reflect that addition in the ComboBox. I have
typed in the "input Ranges" Notes!$I$2:$E$100 to get more fields but that
shows me a to many empty lines in the combobox!

And Again Thanks for all your Help!

Kevin Brenner