List Box in Control Tool Bar

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

 

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

 

[Max]

In design mode,
Right-click on it (ie the List Box) > Properties
Enter as required for: ListFillRange, LinkedCell
(these are the equivalents)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik

 

[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

 

[Dave Peterson]

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

 

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

 

[Dave Peterson]

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

 

[kumik5000]

Looks good, thanks for all your help!!

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