setting a control's text from the value of a cell

  • Thread starter Nondisclosure007
  • Start date


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)
Public Class ThisWorkbook

Private Sub ThisWorkbook_Startup(ByVal sender As Object, ByVal e
As System.EventArgs) Handles Me.Startup
End Sub

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

End Sub

End Class
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.


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
End Sub



I'm sorry about that Ketih, It's Excel 2003.

I was drawing a blank on how to do this in excel.

The whole reason I was using VS2008 was simply, and I know this sounds
lame, was for the type ahead features.

Thank you for below. That will work.

I should probably drop VS2008 and just use the VBA editor w/ Excel
2003 to create the form. I don't think VS2008 is getting me anything,
from functionality in the form perspective, that the VBA editor in
Excel can't.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question