Wierd Listbox problem

Giganews Newsgroups
Subject: Wierd Listbox problem
Posted by:  Gunner (anonymo…@discussions.microsoft.com)
Date: Wed, 22 Oct 2003

Hi,

I have a userform with a listbox I fill with content of a
range. Works fine. But I found out that some of the rows
are NOT needed in the listbox. I therefore made the range
without this rows,like this:
=Tankoversikt!$B$5:$P$12;Tankoversikt!
$B$14:$P$27;Tankoversikt!$B$29:$P$31
(Obviously not row 13 and 28

But when I run the makro I get a wierd error, and are
being kicked out.

Here is the code to fill the listbox:
UserForm6.LBTankRes.RowSource = "Tankoversikt!
LuftgassLager"

Maybe something like this works? If the content of
range"luftgassLager" column A is anything except integer,
do not fill with that row...

Does anyone have a clue?
Anyhelp is appreciated from this guy.

MR.G

Replies