hI
How do i get my userform to startup when the file
opens.

Alvin

within the Workbook Activate add the below code

load userform
userform.show


---
Message posted from http://www.ExcelForum.com/

What Calligra sugests will work, but if you have another workbook ope
whenever you change workbooks and activate the one with the userfor
the userform will be shown.

If you want the userform to only be shown when the workbook is open th
first time put your code in the workbook_open event.

userform.show

Hope this helps

--
Message posted from http://www.ExcelForum.com