boxes with information to enter
 

I've seen some Excel sheets where when you put the cursor in a cell and a
little box opens with something like the range you should input. (not the
"comment" box).

How is this done?

boxes with information to enter
 

Data validation drop down list.

Start he

http://www.contextures.com/xlDataVal01.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"widman" wrote in message
...
I've seen some Excel sheets where when you put the cursor in a cell and a
little box opens with something like the range you should input. (not the
"comment" box).

How is this done?

boxes with information to enter
 

Maybe DataValidationInput Message?


Gord Dibben MS Excel MVP

On Sat, 9 Dec 2006 11:10:01 -0800, widman
wrote:

I've seen some Excel sheets where when you put the cursor in a cell and a
little box opens with something like the range you should input. (not the
"comment" box).

How is this done?

boxes with information to enter
 

That was it, thanks.... Wonder if there is a way to ofset it?

"Gord Dibben" wrote:

Maybe DataValidationInput Message?


Gord Dibben MS Excel MVP

On Sat, 9 Dec 2006 11:10:01 -0800, widman
wrote:

I've seen some Excel sheets where when you put the cursor in a cell and a
little box opens with something like the range you should input. (not the
"comment" box).

How is this done?

boxes with information to enter
 

That was it, thanks.... Wonder if there is a way to ofset it?

If by "ofset" you mean "offset" as in changing its position, you can't.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"widman" wrote in message
...
That was it, thanks.... Wonder if there is a way to ofset it?

"Gord Dibben" wrote:

Maybe DataValidationInput Message?


Gord Dibben MS Excel MVP

On Sat, 9 Dec 2006 11:10:01 -0800, widman

wrote:

I've seen some Excel sheets where when you put the cursor in a cell and
a
little box opens with something like the range you should input. (not
the
"comment" box).

How is this done?