Open Form Automatically

[emo]

I am trying to create a user form to enter data into a spreadsheet. I think it can be simple as all I need to do is have the form that you access from
Data
Form
open automatically.... is this possible or do I need to actually build the form which I am finding confusing.

Thanks.

Emo

 

[Rasm]

Try This

ThisWorkBook is where this code goes - then save - close workbook - now open it again - only use vbmodeless if you want to be able to edit sheet while userform is shown

Private Sub Workbook_Open()
    Load NameOfUserform
    NameOfUserform.Show vbModeless
End Sub

 

[emo]

Thanks,

I guess this means I do have to build a user form.. I will start to plug away at this daunting task.