Write data frm Lotus to excel listbox

HCL Domino Domino Forum
1

Please tell me how to write data into excel list box from Lotus document.

I tried using

xlsheet1.cells(7,6).value = “Renewal MDA”

which is not working.

Thanks in advance…

2

Subject: Write data frm Lotus to excel listbox

It would be better when you state what is not working.

What you could do is record a macro in Excel where you enter a few values in a listbox and copy that code (slightly modified to accomodate for LS) to your LS.

3

Subject: RE: Write data frm Lotus to excel listbox

Thanks Rob. I found out the solution.

In excel we need to create the list box using Forms tool bar and not control tool bar also refer to a cell which has to be referred in properties.If we have A, B and C as three values then if we need to select 3rd value from the list.Then

xlsheet9.cells(61,2).value = “3”

So C would be selected.

Thanks…