I'm trying to pass data to a textbox in a userform. The data may go to one of several text boxes across different userforms, so rather than repeat the code for each one, I thought I would refer to the user form and text box by way of a variable. I've not done this before and don't seem to be getting it right. I've tried Datehere as long, text, string, object but it doesn't seem to work.
The text in range I2 is the name of the userform and the text box (e.g, "Userform1.textbox3"). Does that make sense? Code below
Bookmarks