K
KoenLauriks
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
(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