Although you mention using VS2008, you don't mention which version of Excel
you are using nor is it clear whether you know how to do this within Excel
and just need help with the VS syntax, or whether you are looking for help
with the Excel object model.

I don't have VS2008, so I'll provide a within-Excel solution here to give
you the syntax; hopefully that is what you need and you can adjust it to meet
your specific project requirements.

Private Sub Workbook_Open()
UserForm1.Label1.Caption = Sheet1.Range("A1").Value
UserForm1.Label2.Caption = Sheet1.Range("A2").Value
UserForm1.Show
End Sub

HTH,
Keith


"Nondisclosure007" wrote:

Is this possible?

Here's what I'm looking to do. When the excel workbook loads, I want
it to:
1. Load the Userform first
2. set the text values of controls to a particular cell's value (not
all controls to one cell value).

ie. (and this psudo code mixed w/ vb)
<code
Public Class ThisWorkbook

Private Sub ThisWorkbook_Startup(ByVal sender As Object, ByVal e
As System.EventArgs) Handles Me.Startup
lblParagraph.Text=ActiveWorkbook.Sheets("MySheet") .Activate
Range("A1").Select
End Sub

Private Sub ThisWorkbook_Shutdown(ByVal sender As Object, ByVal e
As System.EventArgs) Handles Me.Shutdown

End Sub

End Class
</code
Now, I'm using VS2008. When I begin to type my label control from the
user form into the startup workbook, it doesn't see the label control
in the type ahead. Or does it go in some sort of 'OnUserFormLoad'
procedure and the workbook_startup just loads the form?

I don't know.

Any help would be appreciated. Thanks.