ListBox Controls

  • Thread starter Thread starter Patty
  • Start date Start date
P

Patty

Is is possible to have more than one linked cell for a
Listbox control? If so how!! THANKS!!!!
 
Patty,

Not that I know of, but you can link another cell to the linked cell. If
the listbox linked cell is A1, then the other cell would be =A1. It'll be
"output only" in that you can't change it (since that would destroy the
link). If you want true two way operation (you can change either cell, and
the other follows, as well as the listbox), it will require an event macro.
 
Patty,

You can enter a named formula in the ListBox Cell link edit box.
The named formula would be created in the Insert | Name| Define dialog box.
It could look something like...

= OFFSET(Sheet1!$F$1,Sheet1!$G$1,0)

If you name this formula "ListLinkFormula" then your entry in the ListBox
Cell link edit box would be simply: =ListLinkFormula

A number entered in G1 would then change the row in column F that the
ListBox Cell link value appears.
This allows you to link another control ( a scroll bar?) to cell G1 and
then, by scrolling, control where the index for the ListBox selection
appears.

Regards,

Jim Cone
San Francisco, CA
----- Original Message -----
From: "Patty" <[email protected]>
Newsgroups: microsoft.public.excel.misc
Sent: Tuesday, November 11, 2003 11:21 AM
Subject: ListBox Controls
 
Back
Top