Value of a cell

[Former Member]

How can I get the value of the cell Item Code on a sales Order ??

If is null call the Shift + F2 if is Not then go to the next field (Item Descrption)

I already has this code

Any help

[Former Member]

If pVal.FormType = 149 And pVal.ItemUID = "38" And pVal.EventType = et_KEY_DOWN And pVal.CharPressed = "9" And pVal.BeforeAction = True Then

BubbleEvent = False

Call applic.SendKeys("+")

[Former Member]

Hello,

you may try this

Dim dst_Value as String
Dim dsa_Matrix as SAPbouiCOM.Matrix

If pVal.FormType = 149 And pVal.ItemUID = "38" And pVal.EventType = et_KEY_DOWN And pVal.CharPressed = "9" And pVal.BeforeAction = True Then
'Get Matrix Object
dsa_Matrix=oApplication.Foms.Item(pVal.ForumUID).Items.Item(Pval.ItemUID).Specific
'Get value of the cell
dst_Value=dsa_Matrix.Columns.Item("1").Cells.Item(Pval.Row).Specific.String
if dst_Value="" then
  BubbleEvent = False
  Call applic.SendKeys("+{F2}")  
end if