LIST bOX

[gLYCH]

CAN ANYONE EXPLAIN TO ME HOW TO SET UP A LIST BOX? I WOULD LIKE TO PLACE THE LIST BOX IN A COLUMN, SO THAT EACH TIME I CLICK ON A CELL ( WITHIN THAT COLUMN)TO ENTER DATA, THE LIST BOX WILL SHOW ON THE SCREEN WITH A LIST OF OPTIONS TO BE USED TO ENTER INTO THAT CELL. aLTERNATIVELY i WOULD LIKE THE LIST TO SHOW SO THAT I CAN SELECT AN ITM FROM THE LIST TO BE PLACED INTO THE CELL.

THANKS FOR YOUR TIME AND ATTENTION

GLYCH

 

[Roger Govier]

Hi

Shhh!!! Don't shout (all capitals are taken as shouting in most NG's, and,
are far more difficult to read)

Take a look at Debra Dalgleish's site for some expert guidance in what you
want to do.
http://www.contextures.com/xlDataVal01.html

--
Regards
Roger Govier

CAN ANYONE EXPLAIN TO ME HOW TO SET UP A LIST BOX? I WOULD LIKE TO PLACE

THE LIST BOX IN A COLUMN, SO THAT EACH TIME I CLICK ON A CELL ( WITHIN THAT
COLUMN)TO ENTER DATA, THE LIST BOX WILL SHOW ON THE SCREEN WITH A LIST OF
OPTIONS TO BE USED TO ENTER INTO THAT CELL. aLTERNATIVELY i WOULD LIKE THE
LIST TO SHOW SO THAT I CAN SELECT AN ITM FROM THE LIST TO BE PLACED INTO THE
CELL.