Cell formatting with 2 variables
 

I would like the user to first select from the following
list:
CP_
FD_
PC_
RFI_

....and then enter a number to append the list item.

Example:
A user first selects RFI_. Then enters the number 32. The
result of RFI_032 is entered in the cell.

Is there a way to do this without requiring the user to
manually append the list item at the command line?

Thanks for your help.

John

Cell formatting with 2 variables
 

John,

Try double clicking the cell before entering the number.

Don Pistulka

"John Hipskind" wrote in message
...
I would like the user to first select from the following
list:
CP_
FD_
PC_
RFI_

...and then enter a number to append the list item.

Example:
A user first selects RFI_. Then enters the number 32. The
result of RFI_032 is entered in the cell.

Is there a way to do this without requiring the user to
manually append the list item at the command line?

Thanks for your help.

John

Cell formatting with 2 variables
 

David,

When I double click on text (as in John's example) the curser ends up at the
end of the text and additional text can be appended. The cursor is already
at the end on the text and does not require moving it to the end. I am using
xl2002 on XP. Please let me know what I am missing here.


Don Pistulka






"David McRitchie" wrote in message
...
Hi John,
I don't think the cursor has any particular position in a cell
after entering from a list. Double-clicking would require moving
the cursor to the end of the entry before typing in more data.

F2 would put you into Edit and at the end, regardless
of whether the cursor would already be there or not.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Don Pistulka" wrote in message
...
John,

Try double clicking the cell before entering the number.

Don Pistulka

"John Hipskind" wrote in message
...
I would like the user to first select from the following
list:
CP_
FD_
PC_
RFI_

...and then enter a number to append the list item.

Example:
A user first selects RFI_. Then enters the number 32. The
result of RFI_032 is entered in the cell.

Is there a way to do this without requiring the user to
manually append the list item at the command line?

Thanks for your help.

John

Cell formatting with 2 variables
 

If it works for you then no problem. I only tested it with a
"pick from list" not from any other list.

If the cursor is in a cell like in the middle of a cell and I
double-click then cursor is in the middle of cell after double-clicking
and not at end of cell. Likewise if I double-click with the
cursor at the beginning of cell, the entry point would be
at the beginning and not at the end.

"Don Pistulka" wrote ...
David,

When I double click on text (as in John's example) the curser ends up at the
end of the text and additional text can be appended. The cursor is already
at the end on the text and does not require moving it to the end. I am using
xl2002 on XP. Please let me know what I am missing here.

Cell formatting with 2 variables
 

Hi David,

This is strange. When I use "pick from list" , then double-click the cell
the curser ends up at the end of the text every time. I'm not trying to
belabor the point, I am only interested in learning and clarifying, so I
don't give out misleading information.

Don Pistulka



"David McRitchie" wrote in message
...
If it works for you then no problem. I only tested it with a
"pick from list" not from any other list.

If the cursor is in a cell like in the middle of a cell and I
double-click then cursor is in the middle of cell after double-clicking
and not at end of cell. Likewise if I double-click with the
cursor at the beginning of cell, the entry point would be
at the beginning and not at the end.

"Don Pistulka" wrote ...
David,

When I double click on text (as in John's example) the curser ends up at
the
end of the text and additional text can be appended. The cursor is
already
at the end on the text and does not require moving it to the end. I am
using
xl2002 on XP. Please let me know what I am missing here.

Cell formatting with 2 variables
 

David,

You are correct. I think I see what was happening now. The example list John
gave us were made up of short three digit words. I was double-clicking in
the middle of the cell, so the curser always ended up at the end. If the
text were longer, clicking in the middle of the cell leaves the curser
elsewhere.

Don Pistulka


"Don Pistulka" wrote in message
...
Hi David,

This is strange. When I use "pick from list" , then double-click the cell
the curser ends up at the end of the text every time. I'm not trying to
belabor the point, I am only interested in learning and clarifying, so I
don't give out misleading information.

Don Pistulka



"David McRitchie" wrote in message
...
If it works for you then no problem. I only tested it with a
"pick from list" not from any other list.

If the cursor is in a cell like in the middle of a cell and I
double-click then cursor is in the middle of cell after double-clicking
and not at end of cell. Likewise if I double-click with the
cursor at the beginning of cell, the entry point would be
at the beginning and not at the end.

"Don Pistulka" wrote ...
David,

When I double click on text (as in John's example) the curser ends up
at
the
end of the text and additional text can be appended. The cursor is
already
at the end on the text and does not require moving it to the end. I am
using
xl2002 on XP. Please let me know what I am missing here.

Cell formatting with 2 variables
 

Hi Don,
Okay see what you mean now, the wider the column (like 45) and
the shorter the data (like 4 characters) the more likely you are going
to be somewhere to the right of the data when you double-click on
the cell; therefore, at end of data.

I can look up shortcut for F2 which is "Activate a cell and the formula bar"
which allows you to edit cell.

I can't find the default for double-click within a cell in Help. All I can really
see is that an empty event macro for Worksheet_BeforeDoubleClick
acts the same way as having no double-click event macro.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Don Pistulka" wrote in message ...
David,

You are correct. I think I see what was happening now. The example list John
gave us were made up of short three digit words. I was double-clicking in
the middle of the cell, so the curser always ended up at the end. If the
text were longer, clicking in the middle of the cell leaves the curser
elsewhere.

Don Pistulka


"Don Pistulka" wrote in message
...
Hi David,

This is strange. When I use "pick from list" , then double-click the cell
the curser ends up at the end of the text every time. I'm not trying to
belabor the point, I am only interested in learning and clarifying, so I
don't give out misleading information.

Don Pistulka



"David McRitchie" wrote in message
...
If it works for you then no problem. I only tested it with a
"pick from list" not from any other list.

If the cursor is in a cell like in the middle of a cell and I
double-click then cursor is in the middle of cell after double-clicking
and not at end of cell. Likewise if I double-click with the
cursor at the beginning of cell, the entry point would be
at the beginning and not at the end.

"Don Pistulka" wrote ...
David,

When I double click on text (as in John's example) the curser ends up
at
the
end of the text and additional text can be appended. The cursor is
already
at the end on the text and does not require moving it to the end. I am
using
xl2002 on XP. Please let me know what I am missing here.