Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Strange error when creating list.

I have a sheet that I want a list in. It has worked without a problem to
create lists in my other sheets using verify-list but in this sheet nothing
happens. What can it be?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 91
Default Strange error when creating list.


how are you creating this list?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Strange error when creating list.

Hi!
I wrote it in the first post. verify cell, then choose list.
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Strange error when creating list.

Calle

Where do you come up with the menu item verifylist?


Gord Dibben MS Excel MVP

On Sat, 8 Jul 2006 14:15:01 -0700, Calle
wrote:

I have a sheet that I want a list in. It has worked without a problem to
create lists in my other sheets using verify-list but in this sheet nothing
happens. What can it be?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Strange error when creating list.

data-verify

I have a swedish version but I think it should be the same


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Strange error when creating list.

I think it is data- validation -list in the english version
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Strange error when creating list.

What is the source of the list? Are you typing in a list or referencing a
group of cells on the sheet that has the list in them?

If you are referencing cells they need to be on the same sheet with the cell
you are setting up.

If you are typing in a list, like
hello,goodbye,good morning,good afternoon
then perhaps if you will tell us what the list contains, we can find
something that Excel doesn't like and is causing the error.

"Calle" wrote:

I think it is data- validation -list in the english version

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Strange error when creating list.

I had to delete that scheet and start a new one, now it works. must have been
a bug
Reply
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
Creating a numercal list Komie Excel Discussion (Misc queries) 1 March 10th 06 10:51 PM
Creating a list in sequential order Mark Jackson Excel Worksheet Functions 6 November 7th 05 11:08 PM
Creating an invoice with a lookup list wings Excel Discussion (Misc queries) 6 October 30th 05 02:37 AM
Creating seperate sheet lists from larger list macquarl Excel Discussion (Misc queries) 1 October 19th 05 10:17 PM
Creating a list from Table Data bry32 Excel Worksheet Functions 4 January 28th 05 07:41 PM


All times are GMT +1. The time now is 04:26 PM.

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

About Us

"It's about Microsoft Excel"