VBA code for Submit/Clear Button?

[cyrous0425]

Good day guys. I'm trying to create a Data Entry using VBA code. I successfully created the User Form but I am having problem about the code in Submit / Clear button. So, basically I just want to fill up my excel sheet what ever I enter in my user form specifically in COLUMN C, I, J, and K. I know that I can do it by just simply using index/match formula,however, there will be thousand's of data to be entered and scrolling through out the data then entering the new data will be time consuming so I tried to create a macro for it. Sorry for my bad English. Here's my sheet by the way https://drive.google.com/open?id=1obslo7TWRXNkoDmkOFDn2OsSqXbO_nJb. Hope someone can point me to the right direction.


Cy
Thanks

 

[cyrous0425]

By the way Sir, Is there a way to run this macro in a protected workbook?
I tried this code and it's work, however, the column that contains index match functions doesn't work:

Public Sub AllowMacros()
              Me.ProtectUserInterfaceOnly:True
           End Sub

 

[Akuini]

By the way Sir, Is there a way to run this macro in a protected workbook?
I tried this code and it's work, however, the column that contains index match functions doesn't work:

Public Sub AllowMacros()
              Me.ProtectUserInterfaceOnly:True
           End Sub

Sorry, I don't know the answer. But since it's a different problem you might want to start a new thread.

 

[cyrous0425]

Ok I will. By the way, every time I add new data my formula in column L become inaccurate. Is there a way to solved it?

 

[Akuini]

Hm, my knowledge of excel formula is very basic, so I can't help you with that.