B
baha
Hello,
I am working on one excel file which shows the database of the
people.That file consist of personal information from people.There are
nearly 2050 id numbers all represent one person.I created two user
forms one for entry one for query.
Basically when you type the id number it will show you the names and
the other details by formula.There is no problem with that.There is
one list box in one of the sheet which input range based on formula
example the formula is baha
baha=OFFSET('r'!$B$1,0,0,COUNTA('r'!$B$1:$B$56),1)
cell link=d15
baha2= OFFSET(INDIRECT(e!$D$11),0,0,COUNTA(INDIRECT(e!$D$11)),1)
D11=ADDRESS(MATCH($B$2,baha,),6,,,"r")& ":" &
ADDRESS(MATCH($B$2,baha,0)+COUNTIF(baha,$B$2)-1,6)
D13= ADDRESS(MATCH($B$2,baha,0),7,,,"r") & ":" & ADDRESS
(MATCH($B$2,baha,0)+COUNTIF(baha,$B$2)-1,7)
Now there is one macro which copy all the entries from one sheet and
insert on the other sheet that's the reason we need all the address
formulas.
Now I want to create that list inside the user form which when ever
you key in the name you can check the records name for that indivudual
person.There shall be one text box which represents the details when
you click the recor of event on the list box.
That file has been created already by one very smart person.All I want
to do make more make up by user forms and VBA.The formulas above
created by me just like an example for you understand how the list box
works.
Second question is, I have second idea complately different from all
above but I need to create one macro which will sort let say
range(B2:B300) I want to sort that according to the number value of
cell B1.Is that possible?
Thank you very much for your intrest.Have a nice day
I am working on one excel file which shows the database of the
people.That file consist of personal information from people.There are
nearly 2050 id numbers all represent one person.I created two user
forms one for entry one for query.
Basically when you type the id number it will show you the names and
the other details by formula.There is no problem with that.There is
one list box in one of the sheet which input range based on formula
example the formula is baha
baha=OFFSET('r'!$B$1,0,0,COUNTA('r'!$B$1:$B$56),1)
cell link=d15
baha2= OFFSET(INDIRECT(e!$D$11),0,0,COUNTA(INDIRECT(e!$D$11)),1)
D11=ADDRESS(MATCH($B$2,baha,),6,,,"r")& ":" &
ADDRESS(MATCH($B$2,baha,0)+COUNTIF(baha,$B$2)-1,6)
D13= ADDRESS(MATCH($B$2,baha,0),7,,,"r") & ":" & ADDRESS
(MATCH($B$2,baha,0)+COUNTIF(baha,$B$2)-1,7)
Now there is one macro which copy all the entries from one sheet and
insert on the other sheet that's the reason we need all the address
formulas.
Now I want to create that list inside the user form which when ever
you key in the name you can check the records name for that indivudual
person.There shall be one text box which represents the details when
you click the recor of event on the list box.
That file has been created already by one very smart person.All I want
to do make more make up by user forms and VBA.The formulas above
created by me just like an example for you understand how the list box
works.
Second question is, I have second idea complately different from all
above but I need to create one macro which will sort let say
range(B2:B300) I want to sort that according to the number value of
cell B1.Is that possible?
Thank you very much for your intrest.Have a nice day