List Box in Control Tool Bar

K

kumik5000

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?
 
D

Dave Peterson

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.
 
K

kumik5000

Hi

Thanks for the prompt response. I tried that and now I get an error message
saying "Could not set the Value property. Invalid property value."

Is there something I need to put in the Value section? Currently it's left
blank.

Thank you
 
D

Dave Peterson

Make sure that the linkedcell is empty or one of the values in the
listfillrange.
 
K

kumik5000

Thanks!

It looks all right now but is there something I have to do to "active" it?
When I click on the box it still seems to be in edit format and I can't click
and display the different options in the cell range.
 
D

Dave Peterson

Make sure you left Design mode (another icon on that control toolbox toolbar)
 
Top