View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nondisclosure007 Nondisclosure007 is offline
external usenet poster
 
Posts: 7
Default setting a control's text from the value of a cell

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.