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
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