Search a data sheet and the result to be displayed in a VBA form with data sheet hiden

Hello all. I am Kevin. I am new here so not sure if such a query was posted before.
i am working on a small project to display the results of a quiz program. What i am looking for is a VBA form that would display options to fill in NAME, Select a GROUP from drop down and also a drop down list of the church names. and once that's done the matching result from the MARKS column against all these three values should be displayed in a box on the VBA form itself, while the data sheet remains hidden at all time.

have attached the spreadsheet. Please help me figure this out.

As sintek rightly points out, you've not explained what the reason behind wanting to 'hide' things is. If it's for data secutity purposes then Excel is not necessarily the tool for you as it's not particularly secure at all.

Having said that, attached is a simple form with code written in a way that should be easy to understand and edit.

Note that any user can access any score. I don't know if that is what you want but if not then you need something a little more complex.

Let us know if you have any questions.

BSB

This is exactly what i was looking for

Hiding is just to keep it neat as you have shown in your sample file nothing more. I have 614 such entries in names and 50 in church list, groups are 6. So names and church list in drop down will be a headache or can it have a searchable drop down?

This is exactly what i wanted. But i have 614 entries Under "name" and 50 in "church name". Is there an option for searchable drop down? else it will be difficult.

Originally Posted by BadlySpelledBuoy

As sintek rightly points out, you've not explained what the reason behind wanting to 'hide' things is. If it's for data secutity purposes then Excel is not necessarily the tool for you as it's not particularly secure at all.

Having said that, attached is a simple form with code written in a way that should be easy to understand and edit.

Note that any user can access any score. I don't know if that is what you want but if not then you need something a little more complex.

Let us know if you have any questions.

BSB

This is exactly what i was looking for

Hiding is just to keep it neat as you have shown in your sample file nothing more. I have 614 such entries in names and 50 in church list, groups are 6. So names and church list in drop down will be a headache or can it have a searchable drop down?

Originally Posted by sintek

If it is as per my post #2 then this is my solution...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Your sample file i cant see the form. It opens to the data sheet...

Originally Posted by kevin098

I have 614 such entries in names and 50 in church list, groups are 6. So names and church list in drop down will be a headache or can it have a searchable drop down?

I had deliberately made it so the Name drop down is dependent on the Group drop down, i.e. only the names that pertain to that group will show when you change it, and the same for the Church drop down based on the Name drop down, but I understand the lists could still be long.
In the atached version I've changed it so when you start typing a name it will jump to that in the list.

Hopefully that's what you meant.

BSB

Originally Posted by BadlySpelledBuoy

I had deliberately made it so the Name drop down is dependent on the Group drop down, i.e. only the names that pertain to that group will show when you change it, and the same for the Church drop down based on the Name drop down, but I understand the lists could still be long.
In the atached version I've changed it so when you start typing a name it will jump to that in the list.

Hopefully that's what you meant.

BSB

Yes sir. This is good... If i may bother u with one more concern. Is it possible to make all the three input fields independent of each other? So that when only the right combination in a row of the three fields are entered then alone the mark in that row will be displayed.... Doing that would reduce each and every person looking up all the marks. Only if it is not too complicated to achieve... Thanks a lot.