wile_e
06-13-2001, 03:12 PM
this is my first project with excel that includes vba. how do i access the user form instead of my worksheets? (when i open up myfile.xls i see the worksheets instead of the form i created.) i have many more questions but ill take them one at a time.
thank you all in advance.
when all else fails......fake it.
mdobs
06-15-2001, 01:03 PM
not positive if this is what your looking for but...........
Go to the project explorer and double click "ThisWorkbook"(you should see a list of the workbook's worksheets and the userform(s) you created). From the dropdown box at top of screen (should display "General" by default) select "Workbook". Directly to the right is another dropdown with workbook events. Select "open". In the module below place the code for starting your userform. When you open your workbook this code will execute. The code should look something like,
Private Sub Workbook_Open()
'some code
userform_name.show
end sub
hope this helps