Textbox auto update

[iainj]

I’m just starting to learn the VBA process with Excel, this problem is probably very basic so forgive me.
I have a cell in excel that is linked to a textbox, if you add text to the textbox it will update the cell. If you close and reopen the application you need to click the textbox to show the value previously added to the cell, can this be viewed automatically.
Here is my code:

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[royUK]

Your code is triggered by events of the textbox and so the textbox has to be selected.

Where is the textbox?

[iainj]

Sorry about the code location ........
The textbox is located on UserForm1

[royUK]

You can set the TextBox's ControlSource Property to A1. This will display A1's value in the textbox & any changes to the textbox or cell will update

[iainj]

Wow that was easy, i thought i would have to write lines of code!
Thanks

[royUK]

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

[hazy13]

Hi Guys,

and waht about updateing the TextBox while macro is running. I've got the text box drawn directly on my spredsheet (so not UserForm) where i want to display files created. The problem is that the displayed message updates only at the end - when macro is not running anymore. So I can only get the message"Done..." which ist the last one of course : ).

Ive tried to use Repaint method but its not working!

Please Login or Register  to view this content.

Any suggestions.

[Fotis1991]

hazy13

Welcome to the forum.

Unfortunately you have to start your own thread as per forum rules.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[hazy13]

OK, thanks for you suggestion, i will do so! Regards!