Listbox linking

[excelmacro]

I have a listbox but i want to use a rowsource that isn't in the same file. how do i do this?

 

[excelmacro]

This message was edited by excelmacro on 2002-04-26 08:43

 

[excelmacro]

I can't get the match formula to work. what does the 9.9999999999999E+307 do anyway?

 

[Aladin Akyurek]

On 2002-04-26 08:29, excelmacro wrote:
I can't get the match formula to work. what does the 9.9999999999999E+307 do anyway?

The MATCH formula with this big number as lookup value returns e.g., the row number of the last numeric cell used.
This message was edited by Aladin Akyurek on 2002-04-26 11:03

 

[excelmacro]

You were right. The reason it wasn't working for me is that my #'s had a ' in front of them (made all #'s have 4 digits regardless of whether they started with a 0 or not)

 

[Aladin Akyurek]

On 2002-04-26 09:53, excelmacro wrote:
You were right. The reason it wasn't working for me is that my #'s had a ' in front of them (made all #'s have 4 digits regardless of whether they started with a 0 or not)

Did you now get the desired linking to the listbox?

 

[excelmacro]

Did you now get the desired linking to the listbox?

It links to the correct cells and everything, but this hasn't eliminated the items in column A that repeat.

in the array column, the values that appear are the same as those in column a (duplicates still present). I'm assuming that this shouldn't be happening.

 

[Aladin Akyurek]

On 2002-04-26 10:49, excelmacro wrote:

Did you now get the desired linking to the listbox?

It links to the correct cells and everything, but this hasn't eliminated the items in column A that repeat.

in the array column, the values that appear are the same as those in column a (duplicates still present). I'm assuming that this shouldn't be happening.

No, that shouldn't be happening.

Do true 0's appear in column A of sheet BBoard?

 

[excelmacro]

I'll give you a couple of examples of them

0006BD
01448E

 

[Aladin Akyurek]

On 2002-04-26 11:07, excelmacro wrote:
I'll give you a couple of examples of them

0006BD
01448E

My apologies. Looking back at the system of formulas, I realized I had given you one that eliminates just blanks while duplicates are left untouched. I edited my original reply such that you will now have, I promise, a list with no dulicates in it.

Aladin

 

[excelmacro]

thanks. that does the trick