Kelly,

Try playing with data validation - you can add/change the validation through
code, and you can have either an in-cell drop down that only allows to pick
from a list (Y or N) or you can limit the entry to number (decimal or whole)
and you can limit the range of input (from 0 to 999, to keep it only three
digits). it will also allow error messages if the wrong info is entered.

Other than that, the only other method I can think of to limit the data
entry into a cell would be to use a worksheet_onchange or _onSelectionChange
event to either check the cell after the data has been changed or to pop up
an input box when the cell in question is selected. But data validation
should be simpler to implement, and using the onchange / onselection change
events are basically only going to mimic the data validation.

Mike
--

__________________________________________________ __________________________
________________
Please reply to newsgroup so everyone can benefit.
Email address is not valid (see sparkingwire.com)
__________________________________________________ __________________________
________________


"Kelly" wrote in message
...
Hi all using the Office 2000 package.

Considering how far you all have helped me come I don't
feel this should be too hard. I am looking for options to
set up specific cells to only allow entry of specific
characters.

One set of cells I only want to allow numbers. They could
be dollars or just three digits indicating mileage.

The other set of cells I want to limit to either a Y or an
N.

I thought of a dropdown box for this but there could be 50
or 75 lines and it would need to be added for each line
thus again increasing the size of my template. It's
already close to 300k and it's seems to take longer and
longer to print as it gets bigger and bigger.

I think I would prefer that an error message to pop up if
the user attempted to enter in something other then the
specified format.

Whatever I choose to use would have to be able to be
replicated by code or copy of format as I use a command
button to add additional expense lines if needed.


Thanks every-one. Any if anyone one is interested in an
expense statement with some pretty cool functionality let
me know I would be happy to share it.

Kelly

Just to add my 2 cents... The same validation can be applied to multiple
cells by either selecting all the cells or copy and paste.

(I know this should be obvious, but wanted to make sure)

steve

"Mike" wrote in message
...
Kelly,

Try playing with data validation - you can add/change the validation
through
code, and you can have either an in-cell drop down that only allows to
pick
from a list (Y or N) or you can limit the entry to number (decimal or
whole)
and you can limit the range of input (from 0 to 999, to keep it only three
digits). it will also allow error messages if the wrong info is entered.

Other than that, the only other method I can think of to limit the data
entry into a cell would be to use a worksheet_onchange or
_onSelectionChange
event to either check the cell after the data has been changed or to pop
up
an input box when the cell in question is selected. But data validation
should be simpler to implement, and using the onchange / onselection
change
events are basically only going to mimic the data validation.

Mike
--


__________________________________________________ __________________________
________________
Please reply to newsgroup so everyone can benefit.
Email address is not valid (see sparkingwire.com)

__________________________________________________ __________________________
________________


"Kelly" wrote in message
...
Hi all using the Office 2000 package.

Considering how far you all have helped me come I don't
feel this should be too hard. I am looking for options to
set up specific cells to only allow entry of specific
characters.

One set of cells I only want to allow numbers. They could
be dollars or just three digits indicating mileage.

The other set of cells I want to limit to either a Y or an
N.

I thought of a dropdown box for this but there could be 50
or 75 lines and it would need to be added for each line
thus again increasing the size of my template. It's
already close to 300k and it's seems to take longer and
longer to print as it gets bigger and bigger.

I think I would prefer that an error message to pop up if
the user attempted to enter in something other then the
specified format.

Whatever I choose to use would have to be able to be
replicated by code or copy of format as I use a command
button to add additional expense lines if needed.


Thanks every-one. Any if anyone one is interested in an
expense statement with some pretty cool functionality let
me know I would be happy to share it.

Kelly

Kelly,

In cell drop-down's are created by data validation

Pick a cell and go "Data" - "Validation"
Under settings in the "Allow" field choose "List"
In the source Tyep "Yes, No, Maybe" (without quotes)
Make sure that the In-cell dropdown box is checked
Click OK

When you select that cell an arrow should appear, if
you click that arrow a list should appear with Yes, No
and Maybe in it. You can select these, just like a
regular drop down.

Dan E

"Kelly" wrote in message ...
Thanks every-one some good advice.

Mike what did you mean by an "in-cell" dropdown?















-----Original Message-----
Just to add my 2 cents... The same validation can be
applied to multiple
cells by either selecting all the cells or copy and paste.

(I know this should be obvious, but wanted to make sure)

steve

"Mike" wrote in message
...
Kelly,

Try playing with data validation - you can add/change
the validation
through
code, and you can have either an in-cell drop down that
only allows to
pick
from a list (Y or N) or you can limit the entry to
number (decimal or
whole)
and you can limit the range of input (from 0 to 999, to
keep it only three
digits). it will also allow error messages if the
wrong info is entered.

Other than that, the only other method I can think of
to limit the data
entry into a cell would be to use a worksheet_onchange
or
_onSelectionChange
event to either check the cell after the data has been
changed or to pop
up
an input box when the cell in question is selected.
But data validation
should be simpler to implement, and using the
onchange / onselection
change
events are basically only going to mimic the data
validation.

Mike
--


_________________________________________________ _________
__________________
________________
Please reply to newsgroup so everyone can benefit.
Email address is not valid (see sparkingwire.com)

_________________________________________________ _________
__________________
________________


"Kelly" wrote in message
...
Hi all using the Office 2000 package.

Considering how far you all have helped me come I
don't
feel this should be too hard. I am looking for
options to
set up specific cells to only allow entry of specific
characters.

One set of cells I only want to allow numbers. They
could
be dollars or just three digits indicating mileage.

The other set of cells I want to limit to either a Y
or an
N.

I thought of a dropdown box for this but there could
be 50
or 75 lines and it would need to be added for each
line
thus again increasing the size of my template. It's
already close to 300k and it's seems to take longer
and
longer to print as it gets bigger and bigger.

I think I would prefer that an error message to pop
up if
the user attempted to enter in something other then
the
specified format.

Whatever I choose to use would have to be able to be
replicated by code or copy of format as I use a
command
button to add additional expense lines if needed.


Thanks every-one. Any if anyone one is interested in
an
expense statement with some pretty cool functionality
let
me know I would be happy to share it.

Kelly






.