Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB control's text/caption is ugly - keeps resizing | Excel Programming | |||
Setting the text in a cell to the text of a cell on a different sheet in the same workbook | Excel Programming | |||
Setting the Chart name as the text from a cell. | Excel Programming | |||
Setting spaces between text in a cell | Excel Programming | |||
Setting text as a background in cell | Excel Worksheet Functions |