I am not really sure what I need for this trick. After several hours of
searching, I thought I would just ask.
I have a drop down list:
Code Code Description
CL01 Client has not provided the files/data required to complete manual(s)
CL02 Client has not made decision on Programming/Database Management
CL03 Client has not made decision on Particular Subject Matter
CL04 Client out of Office/on vacation
CV01 Server down - unable to retrieve documents
CV02 SME - Out of the Office

I want them to be able to choose which code pertains to their situation so
they need to be able to see all this information. But in the actual cell
where it is chosen I only want the code to populate the cell. The Description
I will have populate on another worksheet. Any suggestions? I have even
attempted using the =LEFT or =RIGHT functions. Keep in mind that I havent
been able to crack open the book "VBA for Dummies" - so please be easy.
Where do you get information to learn VBA anyway? I took Basic Programming
back in the stone ages - but I dont remember any of it. Thanks ahead of time.

One play to achieve this ..

A sample construct is available at:
http://cjoint.com/?ldko1w2N2N
Combo box from control toolbox toolbar_Example2.xls
(Link above is good for 14 days)

Assume source data is in Sheet1!A2:B7
where col A = Code Descriptions, col B = Codes
(switch it the other way around, with codes in col B)

Then in say, Sheet2,
Draw a combo box from the control toolbox toolbar
Right-click on the combo box Properties

Set the properties of the combo box to:
ListFillRange: Sheet1!A2:B7
LinkedCell: B2
BoundColumn: 2
ColumnCount: 2
ColumnWidths: 250 pt;60 pt

Click "Exit Design Mode" on the Control Toolbox toolbar, and test it out.
The combo box droplist will display both the code descriptions & codes, while
making a selection will place only the code into the link cell: B2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gayla" wrote:
I am not really sure what I need for this trick. After several hours of
searching, I thought I would just ask.
I have a drop down list:
Code Code Description
CL01 Client has not provided the files/data required to complete manual(s)
CL02 Client has not made decision on Programming/Database Management
CL03 Client has not made decision on Particular Subject Matter
CL04 Client out of Office/on vacation
CV01 Server down - unable to retrieve documents
CV02 SME - Out of the Office

I want them to be able to choose which code pertains to their situation so
they need to be able to see all this information. But in the actual cell
where it is chosen I only want the code to populate the cell. The Description
I will have populate on another worksheet. Any suggestions? I have even
attempted using the =LEFT or =RIGHT functions. Keep in mind that I havent
been able to crack open the book "VBA for Dummies" - so please be easy.
Where do you get information to learn VBA anyway? I took Basic Programming
back in the stone ages - but I dont remember any of it. Thanks ahead of time.

An alternative link to the sample:
http://www.savefile.com/files/221672
Combo box from control toolbox toolbar_Example2.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks for the help. The only problem is the code descriptions will not fit
on the same worksheet as the code. So what I was trying to do is on the
primary worksheet, the person see the drop down list or combo box including
descriptions to choose their code. Only the code would populat that one cell
and the code description would populate on the secondary worksheet.
Another idea I would consider is on the primary worksheet when they click on
the cell to choose their code it would send them to the secondary worksheet
cell where they could choose their code from the drop down box and then
populate the primary worksheet cell with the appropriate code based off their
choice.
Either way will suffice. See example below. Thanks again for your help.

PRIMARY WORKSHEET
Col H

Delay?
Delay Code

Y
Delay Code would go here


SECONDARY WORKSHEET
Col H Col I Col J

Delay Code Days Delayed Delay Detail

CL03 3 Client - No Decision - Subject
Matter


"Max" wrote:

One play to achieve this ..

A sample construct is available at:
http://cjoint.com/?ldko1w2N2N
Combo box from control toolbox toolbar_Example2.xls
(Link above is good for 14 days)

Assume source data is in Sheet1!A2:B7
where col A = Code Descriptions, col B = Codes
(switch it the other way around, with codes in col B)

Then in say, Sheet2,
Draw a combo box from the control toolbox toolbar
Right-click on the combo box Properties

Set the properties of the combo box to:
ListFillRange: Sheet1!A2:B7
LinkedCell: B2
BoundColumn: 2
ColumnCount: 2
ColumnWidths: 250 pt;60 pt

Click "Exit Design Mode" on the Control Toolbox toolbar, and test it out.
The combo box droplist will display both the code descriptions & codes, while
making a selection will place only the code into the link cell: B2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gayla" wrote:
I am not really sure what I need for this trick. After several hours of
searching, I thought I would just ask.
I have a drop down list:
Code Code Description
CL01 Client has not provided the files/data required to complete manual(s)
CL02 Client has not made decision on Programming/Database Management
CL03 Client has not made decision on Particular Subject Matter
CL04 Client out of Office/on vacation
CV01 Server down - unable to retrieve documents
CV02 SME - Out of the Office

I want them to be able to choose which code pertains to their situation so
they need to be able to see all this information. But in the actual cell
where it is chosen I only want the code to populate the cell. The Description
I will have populate on another worksheet. Any suggestions? I have even
attempted using the =LEFT or =RIGHT functions. Keep in mind that I havent
been able to crack open the book "VBA for Dummies" - so please be easy.
Where do you get information to learn VBA anyway? I took Basic Programming
back in the stone ages - but I dont remember any of it. Thanks ahead of time.

Based on the earlier sample set up, for the selected code which appears in
the linked cell B2 in Sheet1

To extract the code description phrase elsewhere, use:
=IF(Sheet1!B2="","",INDEX(Sheet1!A:A,MATCH(Sheet2! B2,Sheet1!B:B,0)))

To repeat the selected code elsewhere, use:
=IF(Sheet2!B2="","",Sheet2!B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gayla" wrote in message
...
Thanks for the help. The only problem is the code descriptions will not
fit
on the same worksheet as the code. So what I was trying to do is on the
primary worksheet, the person see the drop down list or combo box
including
descriptions to choose their code. Only the code would populat that one
cell
and the code description would populate on the secondary worksheet.
Another idea I would consider is on the primary worksheet when they click
on
the cell to choose their code it would send them to the secondary
worksheet
cell where they could choose their code from the drop down box and then
populate the primary worksheet cell with the appropriate code based off
their
choice.
Either way will suffice. See example below. Thanks again for your help.

PRIMARY WORKSHEET
Col H

Delay?
Delay Code

Y
Delay Code would go here


SECONDARY WORKSHEET
Col H Col I Col J

Delay Code Days Delayed Delay Detail

CL03 3 Client - No Decision - Subject
Matter

Some typos in earlier response, sorry, it should have read as:
------
Based on the earlier sample set up, for the selected code which appears in
the linked cell B2 in Sheet2

To extract the code description phrase elsewhere, use:
=IF(Sheet2!B2="","",INDEX(Sheet1!A:A,MATCH(Sheet2! B2,Sheet1!B:B,0)))

To repeat the selected code elsewhere, use:
=IF(Sheet2!B2="","",Sheet2!B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks for the help. I just about have it. The only thing not working is on
my primary worksheet where they choose the appropriate code but at the same
time being able to view the descriptions as well. I only want the code left
listed on that worksheet (primary) in that cell not the description. It is
currently leaving the description listed not the code. I got the secondary
worksheet to work great!
Is there something I am missing?

My primary worksheet is 'Daily-PM'! , cell I want the code in is I8


My source data is Codes!A2:B7

My secondary worksheet is Delays! cell for description is J6 and cell for
code is H6.

Primary Worksheet - I have combo box with:
ListFillRange: Codes!A2:B7
LinkedCell: I8
BoundColumn: 2
ColumnCount: 2
ColumnWidths: 250 pt;60 pt

Here are my formulas:

In J6 -
=IF('Daily-PM'!I8="","",INDEX(Codes!A:A,MATCH('Daily-PM'!I8,Codes!B:B,0)))

In H6 - =IF('Daily-PM'!I8="","",'Daily-PM'!I8)

Thanks.

"Max" wrote:

Some typos in earlier response, sorry, it should have read as:
------
Based on the earlier sample set up, for the selected code which appears in
the linked cell B2 in Sheet2

To extract the code description phrase elsewhere, use:
=IF(Sheet2!B2="","",INDEX(Sheet1!A:A,MATCH(Sheet2! B2,Sheet1!B:B,0)))

To repeat the selected code elsewhere, use:
=IF(Sheet2!B2="","",Sheet2!B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

.. I only want the code left listed on that worksheet (primary)
in that cell not the description. It is currently leaving
the description listed not the code.

I believe you did not switch the source table around as per steps given
earlier / as shown in the sample file.

Ensure that Codes!B2:B7 contain the codes eg: CL01, CL02, etc

while Codes!A2:A7 contain the code descriptions eg:
Client has not provided the files/data required to complete manual(s),
Client has not made decision on Programming/Database Management, etc

(the cols in your original source need to be switched around)

Once you correct it accordingly, your linked cell I8 will then display only
the code.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gayla" wrote in message
...
Thanks for the help. I just about have it. The only thing not working is
on
my primary worksheet where they choose the appropriate code but at the
same
time being able to view the descriptions as well. I only want the code
left
listed on that worksheet (primary) in that cell not the description. It
is
currently leaving the description listed not the code. I got the
secondary
worksheet to work great!
Is there something I am missing?

My primary worksheet is 'Daily-PM'! , cell I want the code in is I8


My source data is Codes!A2:B7

My secondary worksheet is Delays! cell for description is J6 and cell for
code is H6.

Primary Worksheet - I have combo box with:
ListFillRange: Codes!A2:B7
LinkedCell: I8
BoundColumn: 2
ColumnCount: 2
ColumnWidths: 250 pt;60 pt

Here are my formulas:

In J6 -
=IF('Daily-PM'!I8="","",INDEX(Codes!A:A,MATCH('Daily-PM'!I8,Codes!B:B,0)))

In H6 - =IF('Daily-PM'!I8="","",'Daily-PM'!I8)

Thanks.