selection of listbox

[PANKAJUTEKAR]

Dear Sir,

I have one listbox wherein, Motor and SFU are two items.
Now there are different kind value for both Motor and SFU.
Wht i require -
- whn click on "motor", in sheet3- range(a3:a24") items only be select in listbox2.
- whn click on "sfu", in sheet3- range(e3:e24") items only be select in listbox2.

So, can this possible to select the different data in one listbox by clicking perticular value?

 

[meldoc]

Hello

See the Link.

http://www.contextures.com/xlDataVal02.html

 

[PANKAJUTEKAR]

Hello

See the Link.

http://www.contextures.com/xlDataVal02.html

=====
Dear Sir,

Thank You for ur quick reply.
I require in same listbox not different as link says.
Suppose,
Listbox1
motor - if i click on motor = listbox2 shows only range(a3:a25)
Sfu - if i click on sfu = listbox2 shows only range(e3:e25)

Is this possible sir?

 

[GlennUK]

Read the link, it does exactly what you want. How many people did you send private messages to, about your query, exactly?

 

[PANKAJUTEKAR]

Read the link, it does exactly what you want. How many people did you send private messages to, about your query, exactly?

sorry.