VBA

[priya_anthony]

Hi

Just need your help
I have got data in an array i need to put the data on to the data grid
could you just help me with the code part of it

Thanks and Regards
Priya

 

[Andrew Poulsom]

Sorry, what's a data grid?

 

[priya_anthony]

Hi

Actually i have data that is taken from SAP and its in a object oApplHelp
now what i m actually out is to display the retrieved data on to a grid or table

Thanks
Priya

 

[Andrew Poulsom]

Here is a pretty comprehensive tutorial:

http://msdn2.microsoft.com/en-us/library/e0ywh3cz.aspx

 

[priya_anthony]

hi
Actually everything that the link is based on .net frame 3.0
and i m looking out for some code in VBA

Thanks
Priya

 

[Andrew Poulsom]

The link contains Visual Basic code.

You can use the ONKEY method to assign a procedure to a keystroke combination:

Sub Test()
    Application.OnKey "+{F4}", "ShowForm"
End Sub

Sub ShowForm()
    UserForm1.Show
End Sub

 

[priya_anthony]

vba

Hi

I m looking out for help in displaying the data retrieved in an object on to a data grid
Kindly help

 

[priya_anthony]

vba

Hi
actually data can be set to the data member field of the data grid but the thing it need not being seen on to the grid
Kidnly help
Badly stuck

 

[priya_anthony]

Hi

actually i m looking to display the data on to a grid
i.e
Grid1.AddItem ("Applicant no")
Grid1.AddItem ("Applicant name")
now the data in coming on to the next row instead of the next column
How can set the column index for the same
Kindly help
_________________

 

[priya_anthony]

grid

Hi
Actually my data is in the table object oApplhelp and the data is coming from SAP
and the code that i m using is as follows

For i = 1 To oApplHelp.RowCount
UserForm3.Grid1.AddItem = oApplHelp.Value(i, 1)
UserForm3.Grid1.AddItem = oApplHelp.Value(i, 2)
Next i

Now the issue is the data gets added on to the next row instead of the next column

Kidnly help
Badly stuck