Need Help For The Old Excel 97 :)

[SonicWave]

Good day !

I have an Excel problem here. The scenario is as below :

There's a combo box in the worksheet. The combo box will get its item data from another external Excel file, for example, in an central server. When the user clicks on the combo box and choose an item ID, once selected, the combo box value will be used to retrieved appropiate records from the external Excel file. How can I accomplished that ?

To retrieve the item data for the combo box, I try to use a Do-while loop and specify every single cell using LINK to get the value. I know it's not efficient but I really cannot find any other working method.

As for retrieve records using the Combo Box value, at first I use VLINK for every single cell also. Everything works fine until when I tried to delete a single row. My PC just hang there once I delete the row. Any solutions ?

And one more thing, how can I prevent the users from modifying the specific cells contain sensitive data like Price, in the sheet. I tried to use the Tools->Protection to protect, but then after that I can't even delete any rows.

Thanks a lot !

SonicWave

[Ian Mac]

On 2002-05-17 04:11, SonicWave wrote:
Good day !

I have an Excel problem here. The scenario is as below :

There's a combo box in the worksheet. The combo box will get its item data from another external Excel file, for example, in an central server. When the user clicks on the combo box and choose an item ID, once selected, the combo box value will be used to retrieved appropiate records from the external Excel file. How can I accomplished that ?

To retrieve the item data for the combo box, I try to use a Do-while loop and specify every single cell using LINK to get the value. I know it's not efficient but I really cannot find any other working method.

As for retrieve records using the Combo Box value, at first I use VLINK for every single cell also. Everything works fine until when I tried to delete a single row. My PC just hang there once I delete the row. Any solutions ?

And one more thing, how can I prevent the users from modifying the specific cells contain sensitive data like Price, in the sheet. I tried to use the Tools->Protection to protect, but then after that I can't even delete any rows.

Thanks a lot !

SonicWave

The easiset way to get the list into the ComboBox or Data Validation for that matter is to have a hidden sheet with the info on. so Hidden Sheet A1 = '='[Externalbook.xls]ListSheet'!$A$1'

the Name the Range, say ExternalListFillRange

then in the Combobox ListFillRange put '=ExternalListFillRange'

hope this helps