PDA

View Full Version : Display Columns in Listbox only if cells are not empty in a selected Range



desantech
06-29-2018, 09:48 AM
Hello

I didnt search for it yet a lot, but till now I couldnt find anything. My question is:
1. I have a lot of rows with data in 10 different columns (or more), like width, height, color etc but not all cells are filled with info
2. I would like to display all those columns in a listbox that have cell value in a range:
(if my selected range is blue text, then all those yellow columns are displayed even if in range there are some empty cells)



D

d1

OD

L

l1

B

b1
b2
H

h1

h2

R

alpha

t1
W

V

G

CHF pro Stk.
























224

153







35.5

60










1740

2'020.00



274

178






48

60









2440

2'190.00








50



67



92
45










430

496.00








100



67




92
45










860

820.00







246

140.6

67



92
45


156.6
90







1580

2'060.00








45



45



45











50

194.00




so it would look like this:






L
l1

B



H

h1


R

alpha




G

CHF pro Stk.













































































50

67



92

45








430

496.00







100

67



92
45








860

820.00







246
140.6
67


92
45


156.6
90




1580

2'060.00

























Thanks a lot

Kind regards

desantech
06-29-2018, 09:18 PM
Well the question is: (its about a listbox on a userform)



I have a lot of rows with data in 10 different columns (or more), like width, height, color etc but not all cells are filled with info in the columns

I would like to display all those columns in a listbox that have a cell value in a selected range, like selected range is A1:D10, but C1-C10 has no value, so that wont be displayed, but only D10 has a value, so whole D1-D10 will be shown as column in listbox: (if my selected range is blue text, then all those yellow columns are displayed even if in range there are some empty cells)