I have 5 text boxes in a form, numbered 2 to 6.
I have a command button which is supposed to trigger the following action: for each of these text boxes, look up the corresponding value in a sheet and delete it.
I want to do a "For...Next..." type loop and I am trying to use a variable n to refer to the text box number.
I tried TextBox.value but apparently the syntax is not valid.
Can anyone help?
Thanks,
Plix
I have a command button which is supposed to trigger the following action: for each of these text boxes, look up the corresponding value in a sheet and delete it.
I want to do a "For...Next..." type loop and I am trying to use a variable n to refer to the text box number.
I tried TextBox.value but apparently the syntax is not valid.
Can anyone help?
Thanks,
Plix