VBA

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Aug 17, 2007

• #2

Sorry, what's a data grid?

 

Upvote 0

P

priya_anthony

Board Regular

Joined

Jul 17, 2007

Messages

64

• Aug 17, 2007

• #3

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

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Aug 17, 2007

• #4

Here is a pretty comprehensive tutorial:

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

 

Upvote 0

P

priya_anthony

Board Regular

Joined

Jul 17, 2007

Messages

64

• Aug 17, 2007

• #5

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

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Aug 17, 2007

• #6

The link contains Visual Basic code.

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

Code:

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

Sub ShowForm()
    UserForm1.Show
End Sub

 

Upvote 0

P

priya_anthony

Board Regular

Joined

Jul 17, 2007

Messages

64

• Aug 17, 2007

• #7

vba

Hi

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

 

Upvote 0

P

priya_anthony

Board Regular

Joined

Jul 17, 2007

Messages

64

• Aug 17, 2007

• #8

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

 

Upvote 0

P

priya_anthony

Board Regular

Joined

Jul 17, 2007

Messages

64

• Aug 17, 2007

• #9

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
_________________

 

Upvote 0

P

priya_anthony

Board Regular

Joined

Jul 17, 2007

Messages

64

• Aug 18, 2007

• #10

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

 

Upvote 0