connecting four userform to display details on the same spreadsheet

[blanco moola]

hi am new to excel but i have some basic knowledge on programming in excel vba can you help me with this task. am trying to create a school management system and i have created some user forms which you will see from the attached file. i want that when i enter the details in those four user forms the results are displayed on the spread sheedsheet named pupils details when i press save button which is on the user form named career how can i achieve that and if their other cool features you would add i will really grateful. your positive response will be highly appreciated.

 

[Belleke]

With your setup it will take al lot of (unnecessary) coding.
You should use one userform with tabs as you can see in this picture.
Then you won't have problems with multiple submit buttons,finding the right row and any other obstacles

 

[blanco moola]

With your setup it will take al lot of (unnecessary) coding.
You should use one userform with tabs as you can see in this picture.
Then you won't have problems with multiple submit buttons,finding the right row and any other obstacles

View attachment 84702

i will take your advice

 

[Belleke]

If your userform is ready,I can help you with the coding.

 

[blanco moola]

do i need to forward the spreadsheet here?

 

[Belleke]

Your sample is ok,just add a new sample with the changed userform

 

[blanco moola]

i have created a school management system i used a different format from what i posted earlier and the system is working fine. do you have an idea on how to connect an excel spreadsheet to ms access so that it can be my database and my excel userfrom can be my frontend?

 

[Belleke]

The first question is why? Why not make it in Access, it would be a lot easier.
But here you have an example.

 

[blanco moola]

The first question is why? Why not make it in Access, it would be a lot easier.
But here you have an example.

excel makes better userforms and secondly am not good at using ms access, but some adviced that when maing a school management system it would be better if i use ms as a database

 

[Belleke]

Post your example, I have look to make it in access.

 

[blanco moola]

Post your example, I have look to make it in access.

 

[blanco moola]

Post your example, I have look to make it in access.

thats the file

 

[Debaser]

excel makes better userforms and secondly am not good at using ms access, but some adviced that when maing a school management system it would be better if i use ms as a database

You can actually use the same userforms in Access as you do in Excel, though I have no idea why you would for a database setup.

 

[blanco moola]

You can actually use the same userforms in Access as you do in Excel, though I have no idea why you would for a database setup.

thanks for your advice. indeed Education is the kindling of a flame, not the filling of a vessel