View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default List Box in Control Tool Bar

Yep.
Show the control toolbox toolbar
Click on the design mode icon on that control toolbox toolbar.
Select your listbox
click on the properties icon on that control toolbox toolbar.

Look for LinkedCell and ListFillRange in that properties window.

Remember to leave design mode when you're finished.

kumik5000 wrote:

Is there an equivalent of the "input range" and "cell link" in the format
list box to the control tool bar list box? Or do I need to know VBA to
referrence the cell link?



--

Dave Peterson