Hi,
It is better to use a Userform Utility than have objects imbedded into the
worksheet.
send me a sample sheet of your project. No info is shared with any person,
living or presumed dead.

See my Excel stuff at
http://www.geocities.com/excelmarksway


"spydor" wrote:


How do you have a cell read on the spread as a lable (using the label
in a drop-down list) and when selected, the cell will return a constant
value? The cell might read: "Red Widget" but it would return a value
of say: 257. Got any ideas on this one....

Thanks...
Spydor


--
spydor
------------------------------------------------------------------------
spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438
View this thread: http://www.excelforum.com/showthread...hreadid=480383