I have incerted an ActiveX control in my spreadsheet: a Datamatrix label
(scanning label).

I have linked this control with a cell via the LinkedCell property of the
control.

I have made a macro to print labels with a serial number and a Datamatrix
scanning label linked to this serial number. When I run the macro, I can see
that the label changes, every time I change (via the macro code) the cell it
is linked to. However, during printing, the label does not change with the
serial number but stays the same, although the serial number changes.

I do not know what code to write. I have already used:

Activesheet.Shape("datamatrixctrl1").select
selection.LinkedCell = "w5"

but this does not work.

Help!

Kind Regards, Koen Lauriks

I don't know this control, but you should have some documentation to
describe how to use it.

if the control is an ActiveX control, look on the sheet's code page
(right-clicking the sheet tab and select View Code) asnd select the object
in the object dropdown in the upper left side. If it is there, then in the
upper right hand drop down you will see the available methods. Take a look
and see if there's anything there that might assist you


"KoenLauriks" wrote in message
...
I have incerted an ActiveX control in my spreadsheet: a Datamatrix label
(scanning label).

I have linked this control with a cell via the LinkedCell property of the
control.

I have made a macro to print labels with a serial number and a Datamatrix
scanning label linked to this serial number. When I run the macro, I can
see
that the label changes, every time I change (via the macro code) the cell
it
is linked to. However, during printing, the label does not change with the
serial number but stays the same, although the serial number changes.

I do not know what code to write. I have already used:

Activesheet.Shape("datamatrixctrl1").select
selection.LinkedCell = "w5"

but this does not work.

Help!

Kind Regards, Koen Lauriks