I have a UserForm with 12 TextBoxes the values of which I need to enter into a WorkSheet.
I have given these controls tab indexes from 0 to 11.
I have been trying, unsuccessfully, to write code that will do the transfer on the lines of:-
I know that I could accomplish this by using a control name such as "TextBox" & i but this way is not available to me as it is being used already for another purpose.![]()
Please Login or Register to view this content.
I hope that somebody will be able to put me on the right path.
John
Bookmarks