Basic Visual Basic Form

[harrigme]

This may be an easy question for many of you.

I want to create a Form in VB that I can use to reference an excel spreadsheet in Excel. For example, I would like to have several text boxes and in one text box I enter a stock symbol and then in the other boxes, the information from the spreadsheet is populated, such as market cap, volume, industry, etc...

Any help would be appreciated.

Thanks!

 

[JamesW]

Hi there,

You could maybe do it like this:

Create your form, add your textboxes and a command button.

In the command button code (double click on it) enter:

Private Sub CommandButton1_Click()
    sSymbol = TextBox1.Value
    
    TextBox2.Value = WorksheetFunction.VLookup(sSymbol, Range("A1:E100"), 2, False)
    TextBox3.Value = WorksheetFunction.VLookup(sSymbol, Range("A1:E100"), 3, False)
...
End Sub

This is assuming your data is in the Range A1:E100 and the Stock Symbol is in column A. Change as required.

 

[harrigme]

Thanks! That helps a lot.

Another question. It gives me an error when a field is blank. Anyway to correct that?