user form 1

[HOMMER]

is good to use a user form in excel. the form would be linked to cells on a sheet. Is this hard to do and where can i leard how? I know how to make a form, but don't know how to display the form or link it to cells.

 

[DarkSun]

This site might help you a bit.

http://www.microsoft.com/officedev/articles/Opg/012/012.htm

To display the form use this code:

FormName.Show

 

[HOMMER]

for some reason I con not get the form to show where do I put the code?

 

[DarkSun]

Example:

You have created a userform called "FrmTest"

You want this to be displayed when the workbook is opened.

Code is this:

Private Sub Workbook_Open()
FrmTest.Show
End Sub