Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating List Box
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 ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating List Box
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" wrote in message ... 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. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Floating row? | Excel Discussion (Misc queries) | |||
Floating CommandButton | Excel Worksheet Functions | |||
floating list box | Excel Discussion (Misc queries) | |||
Floating Key | Excel Discussion (Misc queries) | |||
FLOATING BOX | Excel Programming |