Prev: resequence my worksheets
Next: Insert Picture using Macro
From: jj on 6 Apr 2010 19:03
I have an inventory spreadsheet that consists of several columns of
information used to assess the condition of equipment. Each row represents an
identified defect in a piece of equipment. In the column 'DefectType' I want
to be able to pick from a list of standard defect types (e.g. broken, torn,
bent, etc) for each row item. I could create a ListBox in the cell under
DefectType column for each row, but that looks pretty ugly and I'd have to do
that everytime I created a new row entry for each new defect found. It would
be easier to type it, but then I might lose my consistent naming for each
defect.

Any ideas how to tab to a cell in a specific column and be able to pick from
a list of items so that one of the items will become the value for that cell?

Thanks

John
From: Tim Williams on 6 Apr 2010 19:25
Data Validation ?

http://www.contextures.com/xlDataVal01.html

Tim


On Apr 6, 4:03 pm, jj <j...(a)discussions.microsoft.com> wrote:
> I have an inventory spreadsheet that consists of several columns of
> information used to assess the condition of equipment. Each row represents an
> identified defect in a piece of equipment. In the column 'DefectType' I want
> to be able to pick from a list of standard defect types (e.g. broken, torn,
> bent, etc) for each row item. I could create a ListBox in the cell under
> DefectType column for each row, but that looks pretty ugly and I'd have to do
> that everytime I created a new row entry for each new defect found. It would
> be easier to type it, but then I might lose my consistent naming for each
> defect.
>
> Any ideas how to tab to a cell in a specific column and be able to pick from
> a list of items so that one of the items will become the value for that cell?
>
> Thanks
>
> John

From: jj on 6 Apr 2010 20:22
THANKS, TIM!! THAT'S EXACTLY WHAT I WANTED.

"Tim Williams" wrote:

> Data Validation ?
>
> http://www.contextures.com/xlDataVal01.html
>
> Tim
>
>
> On Apr 6, 4:03 pm, jj <j...(a)discussions.microsoft.com> wrote:
> > I have an inventory spreadsheet that consists of several columns of
> > information used to assess the condition of equipment. Each row represents an
> > identified defect in a piece of equipment. In the column 'DefectType' I want
> > to be able to pick from a list of standard defect types (e.g. broken, torn,
> > bent, etc) for each row item. I could create a ListBox in the cell under
> > DefectType column for each row, but that looks pretty ugly and I'd have to do
> > that everytime I created a new row entry for each new defect found. It would
> > be easier to type it, but then I might lose my consistent naming for each
> > defect.
> >
> > Any ideas how to tab to a cell in a specific column and be able to pick from
> > a list of items so that one of the items will become the value for that cell?
> >
> > Thanks
> >
> > John
>
> .
>
 | 
Pages: 1
Prev: resequence my worksheets
Next: Insert Picture using Macro