ndendrinos
02-03-2011, 06:37 PM
I’ve created a userform with two lisboxes.
The row source for both are on the same sheet “Product”
Named range (CatalogAM) for listbox1is:
=OFFSET(Products!$A$2,0,0,COUNTA(Invoice!$A:$A),1) Named range (CatalogNZ) for listbox2 is:
=OFFSET(Products!$E$2,0,0,COUNTA(Invoice!$A:$A),1)
Now the strange part.
First time I trigger the userform from sheet “Invoice” I only see
one listing in each of the listboxes
As I keep adding Products to the Invoice I begin to see more listings each time
Now why would that happen?
The row source for both are on the same sheet “Product”
Named range (CatalogAM) for listbox1is:
=OFFSET(Products!$A$2,0,0,COUNTA(Invoice!$A:$A),1) Named range (CatalogNZ) for listbox2 is:
=OFFSET(Products!$E$2,0,0,COUNTA(Invoice!$A:$A),1)
Now the strange part.
First time I trigger the userform from sheet “Invoice” I only see
one listing in each of the listboxes
As I keep adding Products to the Invoice I begin to see more listings each time
Now why would that happen?