-
Display Columns in Listbox only if cells are not empty in a selected Range
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
-
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 A110, 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)
Last edited by desantech; 06-29-2018 at 10:30 PM.
Reason: correction maybe
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules