PDA

View Full Version : Solved: arrays



gmahendru
11-13-2005, 11:48 PM
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
11-14-2005, 01:19 AM
Hi,
No time just now, but there is a similar query here. http://www.vbaexpress.com/forum/showthread.php?t=5811

gmahendru
11-14-2005, 03:23 AM
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
11-14-2005, 04:30 AM
.

gmahendru
11-15-2005, 12:12 AM
Hi,

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

:-)