Cell formatting with 2 variables

  • Thread starter Thread starter John Hipskind
  • Start date Start date
J

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
 
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
 
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.
 
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,

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
 
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.
 
Back
Top