Change ItemNumber in transfer entry

(0) Share

Report

Posted on by Community member

Hi to everybody,

I'm not a IT worker or something like that, however, I'm looking for a way to change the inventary on GP and I was thinking of doing so by VBA.
I would like to scan a code an the split it in two and that the first part gets into Item number and the second part in quantity in the grid zone. But i have find several problems, because even if I achive to split the number, when I try to change the ItemNumber GP doesn't allow me to do it.

This is my code for the windows part

Option Explicit
Dim R() As String

Private Sub Reference_Changed()

R = DividirCB(Reference.Value)

MsgBox /a ver / & R(0)
MsgBox /a ver 2 / & R(1)

End Sub

Private Sub Window_AfterOpen()

Reference.Focus

End Sub

Function DividirCB(Codigo As String)

DividirCB = Split(Codigo, / /)

End Function

This allowme to split the code but I cant do it at the ItemNumber it says that its interdicted

Categories: