Userform - help with initialize

Hi,

I have trouble with userform, my textbox is not filled out unless I click on it. I want it to automatically be filled when I initialize it.

Please Login or Register  to view this content.

You need the code in the initialize event not the textbox change

Please Login or Register  to view this content.

Roy beat me to it (when I "previewed post"), but to add to his suggestion I recommend adding this line of code at the end of your sub:

Please Login or Register  to view this content.

hth
Rob

How are you adding the code/ Is it in the UserForm module?

Attach the workbook containing he userform

Can you please attach an example workbook?

Is your text box actually called "Txtbox"?
Click on it in VBE & press [F4] to bring up the properties & name will be listed somewhere in the property list.

Rob

You've typed the code in from scratch including the initialize. You should select it from the dropdown on the right. It should not be the userform name but

Please Login or Register  to view this content.

No problem