List Box in Control Tool Bar
 

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?

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

List Box in Control Tool Bar
 

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

List Box in Control Tool Bar
 

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

List Box in Control Tool Bar
 

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

kumik5000 wrote:

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

List Box in Control Tool Bar
 

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.

List Box in Control Tool Bar
 

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

kumik5000 wrote:

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

List Box in Control Tool Bar
 

Looks good, thanks for all your help!!

"Dave Peterson" wrote:

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

kumik5000 wrote:

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