Did you review the attachment in my last post?

"ernie" wrote in message
...
Yes it is. When select this particular branch. its stockcode will appear.
--
help me


"Dennis Tucker" wrote:

Does the information you have show a relationship between the "branches"
and
their "stock codes"??

For example within a worksheet
row1 contains all of the "branches"
Now the worksheet is divided into a column of data for each "branch".
Under each "branch" are all of the "stock codes" associated with that
"branch".

See sample attached.

Dennis

"ernie" wrote in message
...
Hi

I am trying to retrieve a range of data (the stock code of different
phones)
from worksheet("Inventory") based on the name of the branches of where
the
phones are stored.

worksheet("Inventory") has branch (Column A) and stock code (Column B)

i have 2 combobox.
combobox1 contains values (name of branches) such as:
1-BS
2-EN
3-HG
4-JE
5-SP
6-TB
7-WS
8-YT

combobox2 will have to retrieve values from the worksheet("Inventory")
based
on the value in combobox1. the values in combobox1 can be found in
column
1
while the values i need for combobox2 can be retrieved from column 2 of
Inventory. however, i have many values for each branch, for example, i
have
many 1-BS and there are many stock codes linked to 1-BS. how to
retrieve
all
the stock code of that particular branch?

Thanks!
--
help me