Possible too - ADD Text While editing a cell
 

Excel 2003 - XP SP2
I have users that enter text into a cell for services provided. Is is
possible while they are entering text (into a cell) to either hot-key a popup
box to select different service codes into the cell while they are editing?
or Like WORD to have some autotext entries based on a forward slash? ..
Please help me get started.

thanks
thom

Possible too - ADD Text While editing a cell
 

Any useful macro is disabled while you're editing the cell.

But other options may include Data|Validation
Debra Dalgleish has some very nice notes if you've never used this feature
befo
http://www.contextures.com/xlDataVal01.html

Or even Tools|autocorrect options

And even typing a unique string for each and then edit|replace to update them
when you're done typing.

thom hoyle wrote:

Excel 2003 - XP SP2
I have users that enter text into a cell for services provided. Is is
possible while they are entering text (into a cell) to either hot-key a popup
box to select different service codes into the cell while they are editing?
or Like WORD to have some autotext entries based on a forward slash? ..
Please help me get started.

thanks
thom

--

Dave Peterson

Possible too - ADD Text While editing a cell
 

Thanks Dave.
Good suggestions, I will check out both.

thom

"Dave Peterson" wrote:

Any useful macro is disabled while you're editing the cell.

But other options may include Data|Validation
Debra Dalgleish has some very nice notes if you've never used this feature
befo
http://www.contextures.com/xlDataVal01.html

Or even Tools|autocorrect options

And even typing a unique string for each and then edit|replace to update them
when you're done typing.

thom hoyle wrote:

Excel 2003 - XP SP2
I have users that enter text into a cell for services provided. Is is
possible while they are entering text (into a cell) to either hot-key a popup
box to select different service codes into the cell while they are editing?
or Like WORD to have some autotext entries based on a forward slash? ..
Please help me get started.

thanks
thom

--

Dave Peterson

Possible too - ADD Text While editing a cell
 

Hey, there were 3 suggestions! <vbg

thom hoyle wrote:

Thanks Dave.
Good suggestions, I will check out both.

thom

<<snipped