Prefilled userform

Hi,

I have a UserForm with only one textbox that when open I want to return a value from a cell in my workbook.
Is this possible?

Regards
Øystein

Hello
Using the User Form 'Initialize' Event:

Please Login or Register  to view this content.

Amend the names/ranges to your requirements.

Hope this helps.
DBY

DBY,

Thanks for youre reply, but the userform still comes up blank.
What do you mean by "User Form 'Initialize' Event"?

Regards
Øystein

In the VBA Project right click your User Form and select View Code. In the right hand (Procedure) drop down box select 'Initialize'. Insert the code so it looks like below:

Please Login or Register  to view this content.

The code should run everytime the Form is opened.

DBY

DBY,

Thank you Worked perfect.

Regards
Øystein