Solved: Userform

[Nicolaf]

Hi,

How can I make a Userform pop up as soon as the excel file is opened?
I know how to link it to a command button and use FormName.Show code but I would like to have Userform ready for use without having to click command button.

Also how can I have Userform pop up in a specific part of excel sheet?
For example in (or around) Cell B4 so top left corner of sheet?

Thanks,
Nix

[Bob Phillips]

In the ThisWorkbook code module

[vba]

Private Sub Workbook_Open()
Userform1.Show
End Sub[/vba]

[Nicolaf]

Great thanks!