Floating List Box

  • Thread starter Thread starter NickOnTheNet
  • Start date Start date
N

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
 
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)

NickOnTheNet said:
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
Click to expand...
creating financial statements
 
Back
Top