Sue,
You may find this helpful
http://www.contextures.com/xlDataVal02.html#Dynamic
Cecil

"Sue" wrote in message
m...
Ok gurus:
Can someone pleeeeaase shed some light on this for me...

I have been asked to create a form in which the user is asked to
select an appropriate General Ledger (GL) account code [via a list
box], based on the nature of the expense they are processing.
Only issue is that there are several legal entities (companies) within
the organisation, each with their own set of [different] GL account
codes (nothing is ever simple around here!)

So I'm hoping to create a macro(?) where when a particular company is
selected (via a validation list), the input range within the
properties of the list box change to reflect the location of the
corresponding codes; the user then makes their selection and the value
is returned to the relevant cell.

EG:

User selects: Company 1
Account Classification List Box diplays set of GL Codes for Company
1...

User selects: Company 2
Account Classification List Box then diplays set of GL Codes for
Company 2

and so on..

there may be an even simpler way to do this??
Really appreciate any guidance here..

Many thanks in advance
Sue :¬)