Hi,

I need advise/help for the following problem:

I have written a VB6 application to add data from a file into Excel and then select the range of data and add arange name to the Excel Name Box.

It works when I have previously assigned a name to the range in excel using the Name Box.

Is there a way to edit the Excel Name Box from a VB form?

Thanks

I should probably go into more detail on this problem...

On the formula bar in Excel there is the Name Box that displays the cell name you are currently in. If you have a range of data...say A1:A10 highlighted, and you click in this name box you can give the selected range a name...say "DataList01". When you hit enter that will store the name in the dropdown list in the next to the Name Box field.

If you then select another cell...say B1 and click Data on the toolbar, then click Validation, you will be given a couple of options. If you set Allow = List and the Source = "DataList01", the cell B2 will have a dropdown list with all the elements from the range A1:A10 that you called "DataList01".

As you know, you can select a range of cells in Excel from VB, but how do give the range you selected a Name using a VB program. I have the correct code to select the range, and if I name the range in Excel first then run my VB program, it works.

Any help on this would be great - thanks