DBGRID ButtonClick

I am using the DBGRID in VB 5.0 and I would like to create a dropdown  by clicking on a cell with the buttonclick event to invoke a dropdown DBGRID or DBLIST. The help manual indicates that the column "BUTTON" property can be used to "dropdown" an external control from a grid cell. Iwould like to know how? and I do not want to have to upgrade to APEX TRUE DBGRID PRO 5.0 to accomplish this. Thanks, Henry   
szylakAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

szylakAuthor Commented:
Adjusted points to 75
0
clifABBCommented:
Place your grid control on a form.  Set column 1 style to button.
Place a listbox on the same form.  Set it's visible property to false.
Place the following code in the grid's ButtonClick event:
Private Sub DBGrid1_ButtonClick(ByVal ColIndex As Integer)

    List1.Width = DBGrid1.Columns(ColIndex).Width
    List1.Left = DBGrid1.Columns(ColIndex).Left + DBGrid1.Left
    List1.Top = DBGrid1.RowTop(.Row) + DBGrid1.RowHeight + DBGrid1.Top
    List1.Visible = True
    List1.ZOrder
End Sub

Place the following code in the listbox's Click event:
Private Sub List1_Click()

    'Code to Process selection
    List1.Visible = False
End Sub
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.