Cell formatting with 2 variables

[John Hipskind]

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

 

[Don Pistulka]

John,

Try double clicking the cell before entering the number.

Don Pistulka

 

[Don Pistulka]

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

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

John,

Try double clicking the cell before entering the number.

Don Pistulka

 

[David McRitchie]

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]

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

 

[Don Pistulka]

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

 

[David McRitchie]

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.