Floating List Box

[NickOnTheNet]

Hi all,
is it possible to produce a floating list box using VBA ?
I want the box to appear at the active cell on doubleclick, and t
populate it with a range from another worksheet

 

[Bob Phillips]

Nick,

Would Data Validation work for you? Data Validation lists can work on other
sheets as long as you set up a named range and reference this name.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi all,
is it possible to produce a floating list box using VBA ?
I want the box to appear at the active cell on doubleclick, and to
populate it with a range from another worksheet.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements