User Forms

[dcaraher]

I currently have a workbook which I am using to manage Procurement Contracts.

The data worksheet consists of 17 Columns ( data filelds) and over 400 Rows (Records).

I was going to try and design a user form to allow simple data entry but this proving beyond my very limited capabilities. I have looked at he built in Form function in Excel 2003, Data - Form, and what it gives me is fit for purpose.

How can I automaticaly open the data form when the work book is opened? I dont want to hide the data from the users I just want to make entering data and searching for specific contracts.

Thanks

[zbor]

You can add Filter in first row and filter out data you like each time. Is that's ok?

If not can you upload example workbook? (avoid sensitive data)

[thompsy121]

Hi,

How can I automaticaly open the data form when the work book is opened?

On your workbook, hit Alt and F11, which brings you to the VB code. You should have a userform under forms...i think the default one is called UserForm1 or whatever you have called it.

Simply paste this code into your workbook...

Private Sub Workbook_Open()
UserForm1.Show 'your form name here.show
End Sub

Hope this helps,

Thanks