ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Strange error when creating list. (https://www.excelbanter.com/excel-discussion-misc-queries/98236-strange-error-when-creating-list.html)

Calle

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?

damorrison

Strange error when creating list.
 

how are you creating this list?


Calle

Strange error when creating list.
 
Hi!
I wrote it in the first post. verify cell, then choose list.

Gord Dibben

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?



Calle

Strange error when creating list.
 
data-verify

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

Calle

Strange error when creating list.
 
I think it is data- validation -list in the english version

JLatham

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


Calle

Strange error when creating list.
 
I had to delete that scheet and start a new one, now it works. must have been
a bug


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com