Menu

floating list box in Excel?

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Hemant_india[_2_] Hemant_india[_2_] is offline

Hemant_india[_2_] is offline

external usenet poster

Posts: 107

Default

floating list box in Excel?

please mail the sheet to

--
hemu

"RBuell" wrote:

I received an Excel spreadsheet from an outside vendor that has very
cool functionality.
It has what I call a "floating listbox" that moves from cell to cell as
I select a different
cell in a column. It doesn't appear to be a normal ActiveX control so
I'm not sure how it
was implemented. The source data for the listbox is located on the
sheet as well but the
text color is set to white so it appears invisible. As I select a
value from the listbox the
underlying cell gets populated. I cannot edit the physical listbox our
look at its properties
so I'm not sure what it is or how it was implemented.

I can copy a cell (with an associated listbox pulldown) to a totally
empty cell in a brand new workbook and the empty cell now contains the
"listbox" functionality.

I've saved the workbook as an Excel 5.0/95 version and the listbox
functionality disappears
so it appears that this is Excel 97 and higher functionality.

If anyone would like the actual spreadsheet to look at please let me
know.

Thanks,

Richard Buell
Denver, CO

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I set up a floating box in Excel?	Nicole	Excel Worksheet Functions	0	July 5th 06 03:55 PM
floating list box	tv	Excel Discussion (Misc queries)	1	April 12th 06 04:25 PM
Floating toolbar and floating comment?	StargateFan[_3_]	Excel Programming	2	December 5th 05 10:26 PM
How to reference the contents of a list in a floating toolbar?	Alvin Wilson	Excel Programming	1	October 6th 05 04:49 PM
Floating List Box	NickOnTheNet	Excel Programming	1	December 6th 03 01:06 PM

All times are GMT +1. The time now is 10:59 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement