Floating List Box

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
 
B

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)

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