|
Subject:
|
Need simple definitions
|
|
Posted By:
|
tomgrady
|
Post Date:
|
12/31/2005 4:08:58 PM
|
Trying to learn VBA, using the book
Excel 2003 VBA
On pg. 20. Code:
First line:
Function InvoiceAmount(ByVal Product As String, ...)
What is ByVal? What is As String? Why this structure?
Second line:
Price=WorksheetFunction.VLookup(Product,Table,3)
Does this mean that Product has already been defined as a name range?
Does this mean that Table is a defined name range?
|
|
Reply By:
|
marcostraf
|
Reply Date:
|
1/3/2006 5:22:35 PM
|
you can't learn a language just with a book.
Install VB6, VBA and all the VB documentation (help or even better MSDN). write some code. if you need help, highlight the word (for example ByVal) and then press the help (F1) button.
Marco
|
|
