live automatic cell update based on another cell

Hi guys,

I am new to VBA coding and still have a lot to learn. have watched several video tutorial at youtube and tried to make my own userform.

example:

Column
D E F G H I J
10 8 10 7 6 6 2

Column L

(sum)
(highest possible score:70)

49


Column K

(HPS/total score)
(% score)

70


Column M

(column K*30%)
(weighted Score)

21



But, so far, i have manage to create (on SHEET1) the ADD, update, find next, find previous buttons and delete button but I am having trouble with column K, L & M. what i want to do is to be able to reflect those on my userform and dynamically update it self in real time whenever i try to update column D,E,F,G,H,I,J is it possible?

also, I'M stuck on creating a search function for a specific Employee Code. whenever i try to write the macro it always give me a run-time error 424.

please help with this and Thank you in advance

Classrecord Beta ver5.0.xlsbClassrecord Beta ver5.0.xlsb
here my file please how can I make my data from Column K,L,M, show up and automatically update everytime I add data on column D,E,F,G,H I,J

Classrecord Beta ver5.0.xlsb
here is the file pls. help how to go about this.