Prev Previous Post   Next Post Next
  #14   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Data Validation

It sure looks like it.

You post looks about 48 minutes (plus or minus a couple of minutes) from this
response.

(woohoo. <vbg)

Rob L wrote:

Now ?

"Dave Peterson" wrote in message
...
Nope. Not yet.

Rob L wrote:

Better now ?

Actually what they say is "Welcome to Queensland. Turn your watch back 10
years..."

Rob L

"Dave Peterson" wrote in message
...
Check your timezone.

Rob L wrote:

Far North Queensland Mate ! We're ahead of EVERYONE !

Rob L
(just checked, and the date and time are correct)

"Pete_UK" wrote in message
...
Rob,

please check your system date - you seem to be a day ahead of the
rest
of
us.

Pete

"Rob L" wrote in message
u...
What you can do is put a ',",^ etc as the first option - so your
list
is
',A,B,C,D. The first option shows up as ' but when chosen is a
blank
cell
(well essentially...)


Rob L

"wild turkey no9" wrote
in
message ...
Don

Good thoughts. I was aware of using separate lists, but for this
sheet I
wanted to define the list as users may add or delete rows. Just
cannot
figure
out how to add a blank option this way.....

"Don" wrote:

I usualy have all my lists on another page. select the range and
name
the
range. Then on the location you want a drop down, choose data /
validation
and list and =rangename

I did see where when you do a data / validation and put a blank
then
comma
then the list, it does not show the blank. above will work or
put a
"."
first?

"wild turkey no9" wrote:

Using the list option, I have six entries that are separated by
commas
entered in the data validation source box. These work fine. How
to
I
add a
blank space as the first choice on the dropdown list?

Thanks

Kevin





--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation Data using Validation Table cell range..... Dermot Excel Discussion (Misc queries) 16 January 5th 10 09:35 PM
Data Validation Update Validation Selection PCreighton Excel Worksheet Functions 3 September 11th 07 03:32 PM
data validation invalid in dynamic validation list ilia Excel Discussion (Misc queries) 0 November 7th 06 12:54 PM
data validation invalid in dynamic validation list ilia Excel Worksheet Functions 0 November 7th 06 12:54 PM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"