Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set tab or enter keys to automatically move to different cells | Excel Discussion (Misc queries) | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Boxes in Forms | Excel Discussion (Misc queries) | |||
In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions | |||
when I enter data in my worksheet, it skips to much lower boxes | Charts and Charting in Excel |