Create List Box By VBA Macro

[delta]

sheet 1 my product name range is A2:A550
in sheet 2 in Cell C1:C10 create list box vba macro only.
so list box show product name
sheet 2 cell B1 value is = 1 then in C1 cell will be show list box show other wise hide
sheet 2 cell B2 value is = 2 then in C2 cell will be show list box show other wise hide
sheet 2 cell B3 value is = 3 then in C3 cell will be show list box show other wise hide
sheet 2 cell B8 value is = 8 then in C8 cell will be show list box show other wise hide
sheet 2 cell B10 value is = 10 then in C10 cell will be show list box show other wise hide

all this is by vba macro

also is possible list box show or hide by worksheet selection change events


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[vletm]

... by worksheet selection change events

 

[Marc L]

all this is by vba macro

For the third time, post at least in the appropriate VBA forum ‼
​

 

[delta]

vletm sir nice answer
but how to select item from list box it is can not select

 

[vletm]

... how to select ... hmm?
as usual ...
1) select any of those You named cells
2) make sure that there is named value
3) after that You'll see listbox
4) just select as You need
it works like You wrote

 

[delta]

nothing is selected
how select Number 370 from list box and
also resize of list box which show only one item

 

[vletm]

hmm... You asked:
sheet 1 my product name range is A2:A550
in sheet 2 in Cell C1:C10 create list box
1) select: as I wrote, activate any of Your named cell, make sure that there is needed number in B-column and from list box select wanted number.
Did You saw that my snapshot? Do I really need to make same with 370?
2) resize: You wanted C1:C10 sized list box and there will be always those 549 items.
>> Think 1st and next write that You just thought - nothing different.
If You ask how to do 1+2 then You would get answer,
but ex 1*2 is another case!