RE: Getting value off another workbook

[philhowell]

i want to set a combo box's control source as a range of cell in a different workbook... i thought it would be something like this...

Windows("makeCount.xls").Application.Sheets("Sheet4").Range(Cells(5, 2), Cells(101, 2))

but sadly not...

Phil

 

[philhowell]

this is quite urgent, so any help would be v.greatfully accepted

 

[Richie(UK)]

Hi Phil,

Not quite sure what you are trying to achieve ... but if you are trying to extract information from a closed workbook try these sites.

http://www.microsoftexceltraining.com/
Select the VBA tab and then 'Extract from workbook' from the menu on the left.

http://j-walk.com/ss/excel/tips/tip82.htm

HTH

 

[philhowell]

dson't think it was as complicated as that, the workbook will be open, all i want to do is populate a combobox with the values from a set range of cells...

 

[philhowell]

any1...?

how do i populate a combox wit data from a set of cell in another open workwook

 

[rikrak]

On 2002-09-20 03:25, philhowell wrote:
any1...?

how do i populate a combox wit data from a set of cell in another open workwook

Hi,

Name the data you are referencing

Say A1:A10 on sheet2 name "dataforbox"

Use the name in the listfillrange: Sheet2!dataforbox