Initialize Textbox on Userform

**Jonathan78** · 04-18-2011, 01:16 PM

Hi all,

I use a textbox on a userform to insert values in cell A1.
on opening the userform however, I'd like it to show the value [last entered] in cell A1.
I googled but could not find the answer to this.
Any ideas?

**Whizbang** · 04-18-2011, 01:28 PM

You can either set the "Linked cell" property of the textbox to "A1", or you can use the UserForm_Initialize() event to feed the value in.

Like this:

Please Login or Register  to view this content.

**Jonathan78** · 04-18-2011, 01:50 PM

Thanks Whizbang!

**royUK** · 04-18-2011, 01:55 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save