software

Hi there,

I have a spreadsheet with some cells setup with a drop-down list containing
Y, N or N/A

This is being used on a TabletPC but if I make a mistake or need to change
back to a blank field I have to invoke the soft keyboard, activate the cell
and hit backspace then close the soft keyboard - quite a long-winded
procedure just to change an incorrect choice!

What I would like to do is add a blank to the list so if I have to revert
back to a blank I can just use the stylus to choose a blank from the chooser
list.

How do I add the option of inputting a blank from the Data Validation List
bearing in mind I am using the Data Validation Source box for entering my
choices directly and not specifying a range of cells?

I have tried adding quot;quot; and even a space to no avail.

Although not a betting man I would wager there is a simple 'fix' for this
but things are only simple if you know how in the first instance! ;^)

--
Thanks amp; regards,
-pp-
There doesn't seem to be a way.
I have tried it even by writing a macro code but that too could not be
made successful as the argument accepts a string with comma delimited
values.
Instead of blank,you could use an another value,say 0, and then select
it and could hide it by checking the zero values box in the
tool-options-view menu.Else,you could use a different character and
conditionally format it to white though it may not look good.Can you just hit the delete key to clear the contents? (I've never used a
tablet pc.)

quot;Pheasant Plucker®quot; wrote:
gt;
gt; Hi there,
gt;
gt; I have a spreadsheet with some cells setup with a drop-down list containing
gt; Y, N or N/A
gt;
gt; This is being used on a TabletPC but if I make a mistake or need to change
gt; back to a blank field I have to invoke the soft keyboard, activate the cell
gt; and hit backspace then close the soft keyboard - quite a long-winded
gt; procedure just to change an incorrect choice!
gt;
gt; What I would like to do is add a blank to the list so if I have to revert
gt; back to a blank I can just use the stylus to choose a blank from the chooser
gt; list.
gt;
gt; How do I add the option of inputting a blank from the Data Validation List
gt; bearing in mind I am using the Data Validation Source box for entering my
gt; choices directly and not specifying a range of cells?
gt;
gt; I have tried adding quot;quot; and even a space to no avail.
gt;
gt; Although not a betting man I would wager there is a simple 'fix' for this
gt; but things are only simple if you know how in the first instance! ;^)
gt;
gt; --
gt; Thanks amp; regards,
gt; -pp-

--

Dave Peterson

Hello again Dave,

When it is in Tablet mode the screen turns through 180 degrees and then
folds down flat and is locked over the keyboard...only the stylus can be
used for input.

The idea was for me to make it easy on myself (being lazy?:-) so it would
actually be much easier to invoke the soft keyboard using the usual 6-tap
operation rather than taking the TabletPC out of the sleeve, unlocking the
keyboard, swivelling the keyboard, hitting the delete key and then reversing
the procedure would be counter-productive to say the least! ;^) lt;duckinggt;

Much quicker while running through the spreadsheet to tap the stylus on the
List box and select the elusive blank...

Thanks amp; kind regards,
-=pp=-

quot;Dave Petersonquot; gt; wrote in message
...
gt; Can you just hit the delete key to clear the contents? (I've never used a
gt; tablet pc.)
gt;
gt; quot;Pheasant Plucker®quot; wrote:
gt; gt;
gt; gt; Hi there,
gt; gt;
gt; gt; I have a spreadsheet with some cells setup with a drop-down list
containing
gt; gt; Y, N or N/A
gt; gt;
gt; gt; This is being used on a TabletPC but if I make a mistake or need to
change
gt; gt; back to a blank field I have to invoke the soft keyboard, activate the
cell
gt; gt; and hit backspace then close the soft keyboard - quite a long-winded
gt; gt; procedure just to change an incorrect choice!
gt; gt;
gt; gt; What I would like to do is add a blank to the list so if I have to
revert
gt; gt; back to a blank I can just use the stylus to choose a blank from the
chooser
gt; gt; list.
gt; gt;
gt; gt; How do I add the option of inputting a blank from the Data Validation
List
gt; gt; bearing in mind I am using the Data Validation Source box for entering
my
gt; gt; choices directly and not specifying a range of cells?
gt; gt;
gt; gt; I have tried adding quot;quot; and even a space to no avail.
gt; gt;
gt; gt; Although not a betting man I would wager there is a simple 'fix' for
this
gt; gt; but things are only simple if you know how in the first instance! ;^)
gt; gt;
gt; gt; --
gt; gt; Thanks amp; regards,
gt; gt; -pp-
gt;
gt; --
gt;
gt; Dave Peterson
Hi

it sounds as though you have your DV set with the list of options
entered directly into the DV dialogue box with comma separators.
Instead, set up a list on another sheet (or unused part of same sheet)
with Y, N, N/A in cells say A1:A3.
In the DV dialogue, select List, but instead of typing the list enter
=Sheet2!A1:A4 which will include a Blank for you.

--
Regards

Roger Govierquot;Pheasant Plucker®quot; gt; wrote in message
...
gt; Hello again Dave,
gt;
gt; When it is in Tablet mode the screen turns through 180 degrees and
gt; then
gt; folds down flat and is locked over the keyboard...only the stylus can
gt; be
gt; used for input.
gt;
gt; The idea was for me to make it easy on myself (being lazy?:-) so it
gt; would
gt; actually be much easier to invoke the soft keyboard using the usual
gt; 6-tap
gt; operation rather than taking the TabletPC out of the sleeve, unlocking
gt; the
gt; keyboard, swivelling the keyboard, hitting the delete key and then
gt; reversing
gt; the procedure would be counter-productive to say the least! ;^)
gt; lt;duckinggt;
gt;
gt; Much quicker while running through the spreadsheet to tap the stylus
gt; on the
gt; List box and select the elusive blank...
gt;
gt; Thanks amp; kind regards,
gt; -=pp=-
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt;gt; Can you just hit the delete key to clear the contents? (I've never
gt;gt; used a
gt;gt; tablet pc.)
gt;gt;
gt;gt; quot;Pheasant Plucker®quot; wrote:
gt;gt; gt;
gt;gt; gt; Hi there,
gt;gt; gt;
gt;gt; gt; I have a spreadsheet with some cells setup with a drop-down list
gt; containing
gt;gt; gt; Y, N or N/A
gt;gt; gt;
gt;gt; gt; This is being used on a TabletPC but if I make a mistake or need to
gt; change
gt;gt; gt; back to a blank field I have to invoke the soft keyboard, activate
gt;gt; gt; the
gt; cell
gt;gt; gt; and hit backspace then close the soft keyboard - quite a
gt;gt; gt; long-winded
gt;gt; gt; procedure just to change an incorrect choice!
gt;gt; gt;
gt;gt; gt; What I would like to do is add a blank to the list so if I have to
gt; revert
gt;gt; gt; back to a blank I can just use the stylus to choose a blank from
gt;gt; gt; the
gt; chooser
gt;gt; gt; list.
gt;gt; gt;
gt;gt; gt; How do I add the option of inputting a blank from the Data
gt;gt; gt; Validation
gt; List
gt;gt; gt; bearing in mind I am using the Data Validation Source box for
gt;gt; gt; entering
gt; my
gt;gt; gt; choices directly and not specifying a range of cells?
gt;gt; gt;
gt;gt; gt; I have tried adding quot;quot; and even a space to no avail.
gt;gt; gt;
gt;gt; gt; Although not a betting man I would wager there is a simple 'fix'
gt;gt; gt; for
gt; this
gt;gt; gt; but things are only simple if you know how in the first instance!
gt;gt; gt; ;^)
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Thanks amp; regards,
gt;gt; gt; -pp-
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Dave Peterson
gt;
gt;
Hi Roger,

Thanks for the quick reply...

You are correct in that I do have the DV set with the list of options
entered directly into the DV dialogue box with comma separators.

I would much prefer to leave it this way if at all possible without setting
up a list on an existing or another sheet?

Anyway if I add an extra sheet and change the Source then I get an error
saying quot;You may not use references to other worksheets or workbooks for Data
Validation criteriaquot;

It does work if I put separate entries on each sheet but that way it is a
lot of work to update if any of the entries change...

Putting all the info on a separate worksheet would be a good compromise -
data all in one place, easy to update etc. but for the problem I described
above.

Is DV supposed to work across a separate worksheet within the same
spreadsheet in Excel 2000?

Thanks amp; regards,
-=pp=-quot;Roger Govierquot; gt; wrote in message
...
gt; Hi
gt;
gt; it sounds as though you have your DV set with the list of options
gt; entered directly into the DV dialogue box with comma separators.
gt; Instead, set up a list on another sheet (or unused part of same sheet)
gt; with Y, N, N/A in cells say A1:A3.
gt; In the DV dialogue, select List, but instead of typing the list enter
gt; =Sheet2!A1:A4 which will include a Blank for you.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; ...
gt; gt; Hello again Dave,
gt; gt;
gt; gt; When it is in Tablet mode the screen turns through 180 degrees and
gt; gt; then
gt; gt; folds down flat and is locked over the keyboard...only the stylus can
gt; gt; be
gt; gt; used for input.
gt; gt;
gt; gt; The idea was for me to make it easy on myself (being lazy?:-) so it
gt; gt; would
gt; gt; actually be much easier to invoke the soft keyboard using the usual
gt; gt; 6-tap
gt; gt; operation rather than taking the TabletPC out of the sleeve, unlocking
gt; gt; the
gt; gt; keyboard, swivelling the keyboard, hitting the delete key and then
gt; gt; reversing
gt; gt; the procedure would be counter-productive to say the least! ;^)
gt; gt; lt;duckinggt;
gt; gt;
gt; gt; Much quicker while running through the spreadsheet to tap the stylus
gt; gt; on the
gt; gt; List box and select the elusive blank...
gt; gt;
gt; gt; Thanks amp; kind regards,
gt; gt; -=pp=-
gt; gt;
gt; gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Can you just hit the delete key to clear the contents? (I've never
gt; gt;gt; used a
gt; gt;gt; tablet pc.)
gt; gt;gt;
gt; gt;gt; quot;Pheasant Plucker®quot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt; Hi there,
gt; gt;gt; gt;
gt; gt;gt; gt; I have a spreadsheet with some cells setup with a drop-down list
gt; gt; containing
gt; gt;gt; gt; Y, N or N/A
gt; gt;gt; gt;
gt; gt;gt; gt; This is being used on a TabletPC but if I make a mistake or need to
gt; gt; change
gt; gt;gt; gt; back to a blank field I have to invoke the soft keyboard, activate
gt; gt;gt; gt; the
gt; gt; cell
gt; gt;gt; gt; and hit backspace then close the soft keyboard - quite a
gt; gt;gt; gt; long-winded
gt; gt;gt; gt; procedure just to change an incorrect choice!
gt; gt;gt; gt;
gt; gt;gt; gt; What I would like to do is add a blank to the list so if I have to
gt; gt; revert
gt; gt;gt; gt; back to a blank I can just use the stylus to choose a blank from
gt; gt;gt; gt; the
gt; gt; chooser
gt; gt;gt; gt; list.
gt; gt;gt; gt;
gt; gt;gt; gt; How do I add the option of inputting a blank from the Data
gt; gt;gt; gt; Validation
gt; gt; List
gt; gt;gt; gt; bearing in mind I am using the Data Validation Source box for
gt; gt;gt; gt; entering
gt; gt; my
gt; gt;gt; gt; choices directly and not specifying a range of cells?
gt; gt;gt; gt;
gt; gt;gt; gt; I have tried adding quot;quot; and even a space to no avail.
gt; gt;gt; gt;
gt; gt;gt; gt; Although not a betting man I would wager there is a simple 'fix'
gt; gt;gt; gt; for
gt; gt; this
gt; gt;gt; gt; but things are only simple if you know how in the first instance!
gt; gt;gt; gt; ;^)
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; Thanks amp; regards,
gt; gt;gt; gt; -pp-
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Dave Peterson
gt; gt;
gt; gt;
gt;
gt;
If you name the range that contains your list, then refer to the name rather
than the range, it will work across sheets.

quot;Pheasant Plucker®quot; gt; wrote in message
...
gt; Hi Roger,
gt;
gt; Thanks for the quick reply...
gt;
gt; You are correct in that I do have the DV set with the list of options
gt; entered directly into the DV dialogue box with comma separators.
gt;
gt; I would much prefer to leave it this way if at all possible without
gt; setting
gt; up a list on an existing or another sheet?
gt;
gt; Anyway if I add an extra sheet and change the Source then I get an error
gt; saying quot;You may not use references to other worksheets or workbooks for
gt; Data
gt; Validation criteriaquot;
gt;
gt; It does work if I put separate entries on each sheet but that way it is a
gt; lot of work to update if any of the entries change...
gt;
gt; Putting all the info on a separate worksheet would be a good compromise -
gt; data all in one place, easy to update etc. but for the problem I described
gt; above.
gt;
gt; Is DV supposed to work across a separate worksheet within the same
gt; spreadsheet in Excel 2000?
gt;
gt; Thanks amp; regards,
gt; -=pp=-
gt;
gt;
gt; quot;Roger Govierquot; gt; wrote in message
gt; ...
gt;gt; Hi
gt;gt;
gt;gt; it sounds as though you have your DV set with the list of options
gt;gt; entered directly into the DV dialogue box with comma separators.
gt;gt; Instead, set up a list on another sheet (or unused part of same sheet)
gt;gt; with Y, N, N/A in cells say A1:A3.
gt;gt; In the DV dialogue, select List, but instead of typing the list enter
gt;gt; =Sheet2!A1:A4 which will include a Blank for you.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello again Dave,
gt;gt; gt;
gt;gt; gt; When it is in Tablet mode the screen turns through 180 degrees and
gt;gt; gt; then
gt;gt; gt; folds down flat and is locked over the keyboard...only the stylus can
gt;gt; gt; be
gt;gt; gt; used for input.
gt;gt; gt;
gt;gt; gt; The idea was for me to make it easy on myself (being lazy?:-) so it
gt;gt; gt; would
gt;gt; gt; actually be much easier to invoke the soft keyboard using the usual
gt;gt; gt; 6-tap
gt;gt; gt; operation rather than taking the TabletPC out of the sleeve, unlocking
gt;gt; gt; the
gt;gt; gt; keyboard, swivelling the keyboard, hitting the delete key and then
gt;gt; gt; reversing
gt;gt; gt; the procedure would be counter-productive to say the least! ;^)
gt;gt; gt; lt;duckinggt;
gt;gt; gt;
gt;gt; gt; Much quicker while running through the spreadsheet to tap the stylus
gt;gt; gt; on the
gt;gt; gt; List box and select the elusive blank...
gt;gt; gt;
gt;gt; gt; Thanks amp; kind regards,
gt;gt; gt; -=pp=-
gt;gt; gt;
gt;gt; gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; Can you just hit the delete key to clear the contents? (I've never
gt;gt; gt;gt; used a
gt;gt; gt;gt; tablet pc.)
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Pheasant Plucker®quot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Hi there,
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have a spreadsheet with some cells setup with a drop-down list
gt;gt; gt; containing
gt;gt; gt;gt; gt; Y, N or N/A
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; This is being used on a TabletPC but if I make a mistake or need to
gt;gt; gt; change
gt;gt; gt;gt; gt; back to a blank field I have to invoke the soft keyboard, activate
gt;gt; gt;gt; gt; the
gt;gt; gt; cell
gt;gt; gt;gt; gt; and hit backspace then close the soft keyboard - quite a
gt;gt; gt;gt; gt; long-winded
gt;gt; gt;gt; gt; procedure just to change an incorrect choice!
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; What I would like to do is add a blank to the list so if I have to
gt;gt; gt; revert
gt;gt; gt;gt; gt; back to a blank I can just use the stylus to choose a blank from
gt;gt; gt;gt; gt; the
gt;gt; gt; chooser
gt;gt; gt;gt; gt; list.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; How do I add the option of inputting a blank from the Data
gt;gt; gt;gt; gt; Validation
gt;gt; gt; List
gt;gt; gt;gt; gt; bearing in mind I am using the Data Validation Source box for
gt;gt; gt;gt; gt; entering
gt;gt; gt; my
gt;gt; gt;gt; gt; choices directly and not specifying a range of cells?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have tried adding quot;quot; and even a space to no avail.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Although not a betting man I would wager there is a simple 'fix'
gt;gt; gt;gt; gt; for
gt;gt; gt; this
gt;gt; gt;gt; gt; but things are only simple if you know how in the first instance!
gt;gt; gt;gt; gt; ;^)
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt; Thanks amp; regards,
gt;gt; gt;gt; gt; -pp-
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt;
gt;gt; gt;gt; Dave Peterson
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
Hi

Using DV lists from other sheets in the same workbook is not normally a
problem. I use it all the time in XL2000 and XL2003.
Using the lists from other Workbooks can be a problem, but there is
usually a way around it.

I played about with achieving your requirement with a type list, and I
think the following will be suitable for your requirement, but note that
it will make the blank cell a text format (which I am assuming is not a
problem because of your other inputs).
Make the DV list Y,N,N/A,',
The last one is the single quote. It will appear on the dropdown as the
single quote mark, but when selected the cell will be blank.

--
Regards

Roger Govierquot;Pheasant Plucker®quot; gt; wrote in message
...
gt; Hi Roger,
gt;
gt; Thanks for the quick reply...
gt;
gt; You are correct in that I do have the DV set with the list of options
gt; entered directly into the DV dialogue box with comma separators.
gt;
gt; I would much prefer to leave it this way if at all possible without
gt; setting
gt; up a list on an existing or another sheet?
gt;
gt; Anyway if I add an extra sheet and change the Source then I get an
gt; error
gt; saying quot;You may not use references to other worksheets or workbooks
gt; for Data
gt; Validation criteriaquot;
gt;
gt; It does work if I put separate entries on each sheet but that way it
gt; is a
gt; lot of work to update if any of the entries change...
gt;
gt; Putting all the info on a separate worksheet would be a good
gt; compromise -
gt; data all in one place, easy to update etc. but for the problem I
gt; described
gt; above.
gt;
gt; Is DV supposed to work across a separate worksheet within the same
gt; spreadsheet in Excel 2000?
gt;
gt; Thanks amp; regards,
gt; -=pp=-
gt;
gt;
gt; quot;Roger Govierquot; gt; wrote in message
gt; ...
gt;gt; Hi
gt;gt;
gt;gt; it sounds as though you have your DV set with the list of options
gt;gt; entered directly into the DV dialogue box with comma separators.
gt;gt; Instead, set up a list on another sheet (or unused part of same
gt;gt; sheet)
gt;gt; with Y, N, N/A in cells say A1:A3.
gt;gt; In the DV dialogue, select List, but instead of typing the list enter
gt;gt; =Sheet2!A1:A4 which will include a Blank for you.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello again Dave,
gt;gt; gt;
gt;gt; gt; When it is in Tablet mode the screen turns through 180 degrees and
gt;gt; gt; then
gt;gt; gt; folds down flat and is locked over the keyboard...only the stylus
gt;gt; gt; can
gt;gt; gt; be
gt;gt; gt; used for input.
gt;gt; gt;
gt;gt; gt; The idea was for me to make it easy on myself (being lazy?:-) so it
gt;gt; gt; would
gt;gt; gt; actually be much easier to invoke the soft keyboard using the usual
gt;gt; gt; 6-tap
gt;gt; gt; operation rather than taking the TabletPC out of the sleeve,
gt;gt; gt; unlocking
gt;gt; gt; the
gt;gt; gt; keyboard, swivelling the keyboard, hitting the delete key and then
gt;gt; gt; reversing
gt;gt; gt; the procedure would be counter-productive to say the least! ;^)
gt;gt; gt; lt;duckinggt;
gt;gt; gt;
gt;gt; gt; Much quicker while running through the spreadsheet to tap the
gt;gt; gt; stylus
gt;gt; gt; on the
gt;gt; gt; List box and select the elusive blank...
gt;gt; gt;
gt;gt; gt; Thanks amp; kind regards,
gt;gt; gt; -=pp=-
gt;gt; gt;
gt;gt; gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; Can you just hit the delete key to clear the contents? (I've
gt;gt; gt;gt; never
gt;gt; gt;gt; used a
gt;gt; gt;gt; tablet pc.)
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Pheasant Plucker®quot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Hi there,
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have a spreadsheet with some cells setup with a drop-down list
gt;gt; gt; containing
gt;gt; gt;gt; gt; Y, N or N/A
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; This is being used on a TabletPC but if I make a mistake or need
gt;gt; gt;gt; gt; to
gt;gt; gt; change
gt;gt; gt;gt; gt; back to a blank field I have to invoke the soft keyboard,
gt;gt; gt;gt; gt; activate
gt;gt; gt;gt; gt; the
gt;gt; gt; cell
gt;gt; gt;gt; gt; and hit backspace then close the soft keyboard - quite a
gt;gt; gt;gt; gt; long-winded
gt;gt; gt;gt; gt; procedure just to change an incorrect choice!
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; What I would like to do is add a blank to the list so if I have
gt;gt; gt;gt; gt; to
gt;gt; gt; revert
gt;gt; gt;gt; gt; back to a blank I can just use the stylus to choose a blank from
gt;gt; gt;gt; gt; the
gt;gt; gt; chooser
gt;gt; gt;gt; gt; list.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; How do I add the option of inputting a blank from the Data
gt;gt; gt;gt; gt; Validation
gt;gt; gt; List
gt;gt; gt;gt; gt; bearing in mind I am using the Data Validation Source box for
gt;gt; gt;gt; gt; entering
gt;gt; gt; my
gt;gt; gt;gt; gt; choices directly and not specifying a range of cells?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have tried adding quot;quot; and even a space to no avail.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Although not a betting man I would wager there is a simple 'fix'
gt;gt; gt;gt; gt; for
gt;gt; gt; this
gt;gt; gt;gt; gt; but things are only simple if you know how in the first
gt;gt; gt;gt; gt; instance!
gt;gt; gt;gt; gt; ;^)
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt; Thanks amp; regards,
gt;gt; gt;gt; gt; -pp-
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt;
gt;gt; gt;gt; Dave Peterson
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
Thanks for the quick reply...please don't forget that you are dealing with a
complete muppet when it comes to Excel so...

How do I name a range?

lt;duckinggt;

Thanks amp; regards,
-=Glyn=-

quot;M. Authementquot; gt; wrote in message
...
gt; If you name the range that contains your list, then refer to the name
rather
gt; than the range, it will work across sheets.
gt;
gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; ...
gt; gt; Hi Roger,
gt; gt;
gt; gt; Thanks for the quick reply...
gt; gt;
gt; gt; You are correct in that I do have the DV set with the list of options
gt; gt; entered directly into the DV dialogue box with comma separators.
gt; gt;
gt; gt; I would much prefer to leave it this way if at all possible without
gt; gt; setting
gt; gt; up a list on an existing or another sheet?
gt; gt;
gt; gt; Anyway if I add an extra sheet and change the Source then I get an error
gt; gt; saying quot;You may not use references to other worksheets or workbooks for
gt; gt; Data
gt; gt; Validation criteriaquot;
gt; gt;
gt; gt; It does work if I put separate entries on each sheet but that way it is
a
gt; gt; lot of work to update if any of the entries change...
gt; gt;
gt; gt; Putting all the info on a separate worksheet would be a good
compromise -
gt; gt; data all in one place, easy to update etc. but for the problem I
described
gt; gt; above.
gt; gt;
gt; gt; Is DV supposed to work across a separate worksheet within the same
gt; gt; spreadsheet in Excel 2000?
gt; gt;
gt; gt; Thanks amp; regards,
gt; gt; -=pp=-
gt; gt;
gt; gt;
gt; gt; quot;Roger Govierquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Hi
gt; gt;gt;
gt; gt;gt; it sounds as though you have your DV set with the list of options
gt; gt;gt; entered directly into the DV dialogue box with comma separators.
gt; gt;gt; Instead, set up a list on another sheet (or unused part of same sheet)
gt; gt;gt; with Y, N, N/A in cells say A1:A3.
gt; gt;gt; In the DV dialogue, select List, but instead of typing the list enter
gt; gt;gt; =Sheet2!A1:A4 which will include a Blank for you.
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards
gt; gt;gt;
gt; gt;gt; Roger Govier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hello again Dave,
gt; gt;gt; gt;
gt; gt;gt; gt; When it is in Tablet mode the screen turns through 180 degrees and
gt; gt;gt; gt; then
gt; gt;gt; gt; folds down flat and is locked over the keyboard...only the stylus can
gt; gt;gt; gt; be
gt; gt;gt; gt; used for input.
gt; gt;gt; gt;
gt; gt;gt; gt; The idea was for me to make it easy on myself (being lazy?:-) so it
gt; gt;gt; gt; would
gt; gt;gt; gt; actually be much easier to invoke the soft keyboard using the usual
gt; gt;gt; gt; 6-tap
gt; gt;gt; gt; operation rather than taking the TabletPC out of the sleeve,
unlocking
gt; gt;gt; gt; the
gt; gt;gt; gt; keyboard, swivelling the keyboard, hitting the delete key and then
gt; gt;gt; gt; reversing
gt; gt;gt; gt; the procedure would be counter-productive to say the least! ;^)
gt; gt;gt; gt; lt;duckinggt;
gt; gt;gt; gt;
gt; gt;gt; gt; Much quicker while running through the spreadsheet to tap the stylus
gt; gt;gt; gt; on the
gt; gt;gt; gt; List box and select the elusive blank...
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks amp; kind regards,
gt; gt;gt; gt; -=pp=-
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt;gt; gt; ...
gt; gt;gt; gt;gt; Can you just hit the delete key to clear the contents? (I've never
gt; gt;gt; gt;gt; used a
gt; gt;gt; gt;gt; tablet pc.)
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Pheasant Plucker®quot; wrote:
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Hi there,
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; I have a spreadsheet with some cells setup with a drop-down list
gt; gt;gt; gt; containing
gt; gt;gt; gt;gt; gt; Y, N or N/A
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; This is being used on a TabletPC but if I make a mistake or need
to
gt; gt;gt; gt; change
gt; gt;gt; gt;gt; gt; back to a blank field I have to invoke the soft keyboard, activate
gt; gt;gt; gt;gt; gt; the
gt; gt;gt; gt; cell
gt; gt;gt; gt;gt; gt; and hit backspace then close the soft keyboard - quite a
gt; gt;gt; gt;gt; gt; long-winded
gt; gt;gt; gt;gt; gt; procedure just to change an incorrect choice!
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; What I would like to do is add a blank to the list so if I have to
gt; gt;gt; gt; revert
gt; gt;gt; gt;gt; gt; back to a blank I can just use the stylus to choose a blank from
gt; gt;gt; gt;gt; gt; the
gt; gt;gt; gt; chooser
gt; gt;gt; gt;gt; gt; list.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; How do I add the option of inputting a blank from the Data
gt; gt;gt; gt;gt; gt; Validation
gt; gt;gt; gt; List
gt; gt;gt; gt;gt; gt; bearing in mind I am using the Data Validation Source box for
gt; gt;gt; gt;gt; gt; entering
gt; gt;gt; gt; my
gt; gt;gt; gt;gt; gt; choices directly and not specifying a range of cells?
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; I have tried adding quot;quot; and even a space to no avail.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Although not a betting man I would wager there is a simple 'fix'
gt; gt;gt; gt;gt; gt; for
gt; gt;gt; gt; this
gt; gt;gt; gt;gt; gt; but things are only simple if you know how in the first instance!
gt; gt;gt; gt;gt; gt; ;^)
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; --
gt; gt;gt; gt;gt; gt; Thanks amp; regards,
gt; gt;gt; gt;gt; gt; -pp-
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Dave Peterson
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
Debra Dalgleish has a nice intro to Data|Validation:
www.contextures.com/xlDataVal01.html

She includes a section on naming ranges:
www.contextures.com/xlDataVal01.html#Name

quot;Pheasant Plucker®quot; wrote:
gt;
gt; Thanks for the quick reply...please don't forget that you are dealing with a
gt; complete muppet when it comes to Excel so...
gt;
gt; How do I name a range?
gt;
gt; lt;duckinggt;
gt;
gt; Thanks amp; regards,
gt; -=Glyn=-
gt;
gt; quot;M. Authementquot; gt; wrote in message
gt; ...
gt; gt; If you name the range that contains your list, then refer to the name
gt; rather
gt; gt; than the range, it will work across sheets.
gt; gt;
gt; gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi Roger,
gt; gt; gt;
gt; gt; gt; Thanks for the quick reply...
gt; gt; gt;
gt; gt; gt; You are correct in that I do have the DV set with the list of options
gt; gt; gt; entered directly into the DV dialogue box with comma separators.
gt; gt; gt;
gt; gt; gt; I would much prefer to leave it this way if at all possible without
gt; gt; gt; setting
gt; gt; gt; up a list on an existing or another sheet?
gt; gt; gt;
gt; gt; gt; Anyway if I add an extra sheet and change the Source then I get an error
gt; gt; gt; saying quot;You may not use references to other worksheets or workbooks for
gt; gt; gt; Data
gt; gt; gt; Validation criteriaquot;
gt; gt; gt;
gt; gt; gt; It does work if I put separate entries on each sheet but that way it is
gt; a
gt; gt; gt; lot of work to update if any of the entries change...
gt; gt; gt;
gt; gt; gt; Putting all the info on a separate worksheet would be a good
gt; compromise -
gt; gt; gt; data all in one place, easy to update etc. but for the problem I
gt; described
gt; gt; gt; above.
gt; gt; gt;
gt; gt; gt; Is DV supposed to work across a separate worksheet within the same
gt; gt; gt; spreadsheet in Excel 2000?
gt; gt; gt;
gt; gt; gt; Thanks amp; regards,
gt; gt; gt; -=pp=-
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Roger Govierquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt;gt; Hi
gt; gt; gt;gt;
gt; gt; gt;gt; it sounds as though you have your DV set with the list of options
gt; gt; gt;gt; entered directly into the DV dialogue box with comma separators.
gt; gt; gt;gt; Instead, set up a list on another sheet (or unused part of same sheet)
gt; gt; gt;gt; with Y, N, N/A in cells say A1:A3.
gt; gt; gt;gt; In the DV dialogue, select List, but instead of typing the list enter
gt; gt; gt;gt; =Sheet2!A1:A4 which will include a Blank for you.
gt; gt; gt;gt;
gt; gt; gt;gt; --
gt; gt; gt;gt; Regards
gt; gt; gt;gt;
gt; gt; gt;gt; Roger Govier
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; gt; gt;gt; ...
gt; gt; gt;gt; gt; Hello again Dave,
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; When it is in Tablet mode the screen turns through 180 degrees and
gt; gt; gt;gt; gt; then
gt; gt; gt;gt; gt; folds down flat and is locked over the keyboard...only the stylus can
gt; gt; gt;gt; gt; be
gt; gt; gt;gt; gt; used for input.
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; The idea was for me to make it easy on myself (being lazy?:-) so it
gt; gt; gt;gt; gt; would
gt; gt; gt;gt; gt; actually be much easier to invoke the soft keyboard using the usual
gt; gt; gt;gt; gt; 6-tap
gt; gt; gt;gt; gt; operation rather than taking the TabletPC out of the sleeve,
gt; unlocking
gt; gt; gt;gt; gt; the
gt; gt; gt;gt; gt; keyboard, swivelling the keyboard, hitting the delete key and then
gt; gt; gt;gt; gt; reversing
gt; gt; gt;gt; gt; the procedure would be counter-productive to say the least! ;^)
gt; gt; gt;gt; gt; lt;duckinggt;
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Much quicker while running through the spreadsheet to tap the stylus
gt; gt; gt;gt; gt; on the
gt; gt; gt;gt; gt; List box and select the elusive blank...
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Thanks amp; kind regards,
gt; gt; gt;gt; gt; -=pp=-
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt; gt;gt; gt; ...
gt; gt; gt;gt; gt;gt; Can you just hit the delete key to clear the contents? (I've never
gt; gt; gt;gt; gt;gt; used a
gt; gt; gt;gt; gt;gt; tablet pc.)
gt; gt; gt;gt; gt;gt;
gt; gt; gt;gt; gt;gt; quot;Pheasant Plucker®quot; wrote:
gt; gt; gt;gt; gt;gt; gt;
gt; gt; gt;gt; gt;gt; gt; Hi there,
gt; gt; gt;gt; gt;gt; gt;
gt; gt; gt;gt; gt;gt; gt; I have a spreadsheet with some cells setup with a drop-down list
gt; gt; gt;gt; gt; containing
gt; gt; gt;gt; gt;gt; gt; Y, N or N/A
gt; gt; gt;gt; gt;gt; gt;
gt; gt; gt;gt; gt;gt; gt; This is being used on a TabletPC but if I make a mistake or need
gt; to
gt; gt; gt;gt; gt; change
gt; gt; gt;gt; gt;gt; gt; back to a blank field I have to invoke the soft keyboard, activate
gt; gt; gt;gt; gt;gt; gt; the
gt; gt; gt;gt; gt; cell
gt; gt; gt;gt; gt;gt; gt; and hit backspace then close the soft keyboard - quite a
gt; gt; gt;gt; gt;gt; gt; long-winded
gt; gt; gt;gt; gt;gt; gt; procedure just to change an incorrect choice!
gt; gt; gt;gt; gt;gt; gt;
gt; gt; gt;gt; gt;gt; gt; What I would like to do is add a blank to the list so if I have to
gt; gt; gt;gt; gt; revert
gt; gt; gt;gt; gt;gt; gt; back to a blank I can just use the stylus to choose a blank from
gt; gt; gt;gt; gt;gt; gt; the
gt; gt; gt;gt; gt; chooser
gt; gt; gt;gt; gt;gt; gt; list.
gt; gt; gt;gt; gt;gt; gt;
gt; gt; gt;gt; gt;gt; gt; How do I add the option of inputting a blank from the Data
gt; gt; gt;gt; gt;gt; gt; Validation
gt; gt; gt;gt; gt; List
gt; gt; gt;gt; gt;gt; gt; bearing in mind I am using the Data Validation Source box for
gt; gt; gt;gt; gt;gt; gt; entering
gt; gt; gt;gt; gt; my
gt; gt; gt;gt; gt;gt; gt; choices directly and not specifying a range of cells?
gt; gt; gt;gt; gt;gt; gt;
gt; gt; gt;gt; gt;gt; gt; I have tried adding quot;quot; and even a space to no avail.
gt; gt; gt;gt; gt;gt; gt;
gt; gt; gt;gt; gt;gt; gt; Although not a betting man I would wager there is a simple 'fix'
gt; gt; gt;gt; gt;gt; gt; for
gt; gt; gt;gt; gt; this
gt; gt; gt;gt; gt;gt; gt; but things are only simple if you know how in the first instance!
gt; gt; gt;gt; gt;gt; gt; ;^)
gt; gt; gt;gt; gt;gt; gt;
gt; gt; gt;gt; gt;gt; gt; --
gt; gt; gt;gt; gt;gt; gt; Thanks amp; regards,
gt; gt; gt;gt; gt;gt; gt; -pp-
gt; gt; gt;gt; gt;gt;
gt; gt; gt;gt; gt;gt; --
gt; gt; gt;gt; gt;gt;
gt; gt; gt;gt; gt;gt; Dave Peterson
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson