manipulate userform from excel sheet

[kosherboy]

Hi,
i'm having some userfrom issues.
I have a workbook with a simple code that opens a userform and populates the textbox with the word "Hi".
The issue is that the first time the code is run it won't display anything, the second time it will display "Hi".
If i then enter the code and change "hi" to (say) "Bye", so when i run the code again the useform will show "Hi" and only the 2nd time around will it display "Bye".
It's as if the code stores information internally, which i did not know!.
Here's the code:

Please Login or Register  to view this content.

(for some reason i am having trouble uploading a workbook so i hope this is enough information)
Any help on this would be greatly appreciated.

[DBY]

Hello
On the User Form 'Initialize' Event put the code:

Please Login or Register  to view this content.

When the form is opened it should show the text string assigned to Text Box 1.

Alterntatively, swap the code around:

Please Login or Register  to view this content.

DBY

[kosherboy]

Hello
On the User Form 'Initialize' Event put the code:

Please Login or Register  to view this content.

When the form is opened it should show the text string assigned to Text Box 1.

DBY

Thanks.
Problem is that when i open the userform manually i don't want the textbox to be filled, i only want it filled when i call the userform from a button on a sheet.

[DBY]

Perhaps you didn't see my edit, you can amend the order of the code on your button click:

Please Login or Register  to view this content.

the text box value is then assigned before the form is opened from the button click, I should have put this solution first, sorry.

[kosherboy]

Thanks DBY,
And you're right, i responded to you before you did the edit.
Btw, i have no idea why the code was acting funny and why your idea resolved it? Can you briefly explain it to me?

[DBY]

Glad it's resolved. To be honest, I'm not an expert in VBA and I'm not sure why but it seems any object values have to be applied before the form is initialized as the code stops when the form opens. A second trigger seems necessary to insert the text box value from memory. If any VBA experts here can explain the logic I too would be interested to know.

Thanks for the Rep mark.