Solved: arrays

[gmahendru]

Hi all,

I am doing one project in excel with userform.

I am struck at one point... the problem is I ve two range YEAR and OFFER..

corresponding to year I ve offer no 1,2,3 etc...

for eg. in year 2002 i ve offer no 1,2... then for 2003 i ve offer no. 1,2,3...

Now i m making a Userform where i should select the Year and it should give offer no corresponding to that year and then when i select offer no it should give me the list entered in that offer no.

Please refer to attach file for details.

People help me please.. this is my first project in VB

Thanks in advance

Gautam Mahendru

[mdmackillop]

Hi,
No time just now, but there is a similar query here. http://www.vbaexpress.com/forum/showthread.php?t=5811

[gmahendru]

Hi,

That was my query earlier but now the requirement has changed... at that time i had two lists of "A" and "B" was defined before but this time the list "A" and "B" are generated on user input.... its not pre-defined...

I hope i m able to explain it properly...


thanks

[Bob Phillips]

.

[gmahendru]

Hi,

Thanks a lot for the help... My project is complete...

:-)