How can I code my Userform so that the TexBox called EmailTo specifically references to cell B1 on the sheet EmailSettings
The text box should always show only the data in the cell, and change the data when it is changed in the text box.
How can I code my Userform so that the TexBox called EmailTo specifically references to cell B1 on the sheet EmailSettings
The text box should always show only the data in the cell, and change the data when it is changed in the text box.
Maybe something like this:
Please Login or Register to view this content.
Thank you, that adds the data to the cells, however when I close and re open the userform I would like that data to show in the TextBoxes again.
You could use a macro such as the following to open your userform and write the value of B1 back to the textbox.
Please Login or Register to view this content.
Thank you that worked. The only change I had to make was to reverse the order, so the Textbox value codes came first (otherwise they still displayed blank).
My pleasure!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks