User Form

[timmckean]

I am creating a database for mark entry, I have the different sections in frames and I have a combo box which is populated from the spreadsheet for the list of students. I would like a VBA code that populates their marks for each section when that particular student is chosen and be able to edit the mark in the cell via the user form. Help please?user form.jpg

[mike7952]

Hello timmckean and welcome to the forum.

Its very hard to help from a pic. If you can upload the workbook it would help us to help you.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[timmckean]

Here is the attached spreadsheet file, your help is appreciated

[mike7952]

Here's a good start that should get you going. I dont have to much time today but if you still need help I'll be around tomorrow.


model.xlsm

[timmckean]

That's really helpful so thank you, however I have added a macro command button as I also need the data that I then enter into the user form to udpate the corresponding cells in the work sheet. I am unsure what coding this requires, could you help me with this please?

[timmckean]

This is the most up to date version of the model, I hope this helps.