PDA

View Full Version : Finding with userform



sem+eda#r
11-11-2007, 01:48 AM
Hi..
I am new in VBA and vbaexpress..
I have started studying excel just one week ago.
In the attached file ı made two userform.
For userform1;
when i write student name it must be apear in the listbox and when i click it, his/her class and point must be apear in the testbox2 and testbox3.

For userform2;
when i write class and point, the student name must be apear in the testbox3..
I learned using exel but i am very new for coding vba.. How can i write ths code?

Bob Phillips
11-11-2007, 03:34 AM
What exactly are you asking to do, the forms just seem like a set of controls to me.

You say write student name, class and point, but that means nothing to me in this context.

sem+eda#r
11-11-2007, 09:30 AM
i want to search and find class and point belong to student name which i will write in the textbox1-userform1.
...... search and find student name which is owner of point and class in the textbox1 and texbox2-userform2..
i need code that will make this search..
Thanks...

AlexAlexon
11-11-2007, 09:59 AM
Is it OK if you change textbox with combobox?

sem+eda#r
11-11-2007, 10:04 AM
i don't know..