Command Ok button Userform

[RJ1969]

Hi
Help! Sorry, my knowledge with the VBA is very minimal.

I attached a sample file. When I click the button and fill the fields from the userform but when I click "OK", it does not appear in the worksheet accordingly.
I have all the vba codes that I thought it will work.

The checkbox is perfectly works, not problem on it.

Also, if you can also fix the "Clear Entry" code and "UNDO" codes... please.

Thank you.

[vba_php]

do you see what I did in the below images? all of these checks:

?headerArr(n * 2)
B5
?Controls("TextBox" & (n + 1))

?n+1
 1 
?frmInputs.TextBo5
test value
?"TextBox" & (n + 1)
TextBox1
?Controls("TextBox1")
?frmInputs.Controls("TextBo5")
test value

you are doing:

?Controls("TextBox" & (n + 1))

which results as:

?Controls("TextBox1")

it seems that excel finds that invalid. try:

frmInputs.Controls("TextBox" & (n + 1))

as in image 3 below. you need a parent for textbox & (n+1). also, your code, IMO, is WAY too complex. the divisions and multiplications are not necessary whatsoever. it really should be a simple as this (common sense sample, not actual code):

dim array (control names of boxes in here)
dim c as long
   for  c = lbound(array) to ubound(array)
      range(cell_address) = frmInputs.controls(array(c))
   next c

[RJ1969]

Hi
Wow! Can you add those codes in the sample worksheet and forward the updated worksheet. Like i said i have a minimal knowledge in vba codes. I don’t know what to do. Please... thank you

[vba_php]

I will not fix your actual file, as that is quite a bit of work. I would require money for that. However, it is very easy to copy the attached example and do for yourself. Can you? It should be very easy, because what I am showing you here can be mirrored or replicated by you to do the very same thing for your file. I have given 2 examples of code that can be written. both are very simple and very similar. just 2-3 lines difference between the 2. let us know if you get stuck.

[romperstomper]

The only thing wrong with your OK button is that Textbox5 is actually called TextBo5 instead. Change that to TextBox5 and it should be OK.

[vba_php]

speaking to me, rorya? because that was his doing.

[RJ1969]

Thank you.