How VBA Excel handling the Lookup with multiple "index"?

J

Johan2000

Programming VBA in Excel is realy fun because end user
can always adjust the output format (adjust the style or cell) before print.

1. As I'm a vFoxpro9 programmer, I still can't figure out how VBA
do something (like in VFP9) such as searching a table with multiple keys
Excel as I know don't have index key, so the table must sorted when
user request a specific fields?

In VFP9
use product
set order to product_no
seek cProductNo
set order to supplier
seek .....

2. Is there any doc or book for VFP9 user to learn VBA Excel???

thanks so much....
 

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

Similar Threads

VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Help with Index formula 2
Excel 2010/2007 - How much can be done with Custom Validation? 7
Access doesn't always close (Excel VBA) & passing parameters 9
Handling Multiple Filenames 1
VBA Copy multiple columns with the same heading from one sheet to another 0
How to Add Field with Index 7
Problem importing Access Choose function into Excel via VBA - skip 1

Top