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" <(E-Mail Removed)> wrote in message
news:0C9221EB-DB0F-4DD9-A3D4-(E-Mail Removed)...
> 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
>
|
Similar Threads
