Combo Box

[Ben]

I am trying to duplicate what another person did for consistency but
can't figure it out.

A Combo Box appears with the black upside-down triangle at the right
side of the object. This triangle appears on a printed page just as
it appears onscreen. There is another option for a "drop-down box",
however, that I can not figure out how to duplicate. A cell appears
to just have numbers or text in it, but when the cell is selected the
black triangle appears, giving options to select. I can not figure
out how to create this in other cells, or even edit the referenced
cells which provide the options. The cell prints just like a normal
cell - without showing the black triangle drop-down box.

Please help! Our company is cheap and out-dated, so we have excel
2000.

 

[Jim Cone]

Sounds like data validation using a list.
Find it on the menu bar: Data | Validation

"Cheap and out-dated" is better than "impulsive and faddish".
Be glad you don't have to relearn Excel with xl2007.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



I am trying to duplicate what another person did for consistency but
can't figure it out.

A Combo Box appears with the black upside-down triangle at the right
side of the object. This triangle appears on a printed page just as
it appears onscreen. There is another option for a "drop-down box",
however, that I can not figure out how to duplicate. A cell appears
to just have numbers or text in it, but when the cell is selected the
black triangle appears, giving options to select. I can not figure
out how to create this in other cells, or even edit the referenced
cells which provide the options. The cell prints just like a normal
cell - without showing the black triangle drop-down box.

Please help! Our company is cheap and out-dated, so we have excel
2000.

 

[Ben]

Sweet! You are absolutely right. I never would have found that,
thanks!

I suppose too much change would be a problem too. Don't fix it if it
isn't broken? There have to be some good features in 2007 though...I
would enjoy the revamped conditional formatting as opposed to the very
limited 3 conditions available in 2000, but for most things it isn't
bad. I work for an engineering company and our main design program is
left over from the DOS based days so we run it in some sort of portal
on windows...and there's no mouse support!

Thanks again,
Ben