Book - Microsoft Office Excel 2003: Inside Out

[martialtiger]

Is anyone familiar with this book? I had a question regarding one o
the topics regarding the use of INDEX function with a list control t
create a data browser (p754). I was wondering if there was a mor
indepth guide to building a Data Browser similar to the one used in th
book? :confused

 

[Debra Dalgleish]

I have the Excel 2002 version of the book, but it should be similar.

The Alpaca.xls file on the CD has the sample workbook. The file uses a
listbox from the Forms toolbar, and the next page in the book has
instructions for setting it up.

You could use a data validation list, instead of a listbox. The Index
formulas are the key to making the data change. They return information
based on the selection in the listbox, which is linked to a worksheet cell.

There is a macro warning when the workbook opens, because the workbook
contains an empty module. No macros are used in the workbook.

 

[Karl]

I bought the said book yesterday

It seems quite easy

I have just tried it on the customer spread sheet that comes with the book
and got it working in a couple of minutes - what part are you having a
problem with ?

 

[Karl]

File is on the disk with thw 2003 book also

I have the Excel 2002 version of the book, but it should be similar.

The Alpaca.xls file on the CD has the sample workbook. The file uses a
listbox from the Forms toolbar, and the next page in the book has
instructions for setting it up.

You could use a data validation list, instead of a listbox. The Index
formulas are the key to making the data change. They return information
based on the selection in the listbox, which is linked to a worksheet cell.

There is a macro warning when the workbook opens, because the workbook
contains an empty module. No macros are used in the workbook.

 

[martialtiger]

Thanks Everyone for the response.

I will take a look at the example spreadsheet. I don't have any rea
problems with it right now. I just wanted to know if anyone wa
familiar with it.

You guys are awesome