• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1476
  • Last Modified:

VideoSoft vsflex control

I'm testing this grid control and I want the combobox in a cell to drop down then I click on it. It only works when I use the keybord, I thougth the following code would work but it doesn't any idees? Which grid control do you prefer, why?


Private Sub vsFlexArray1_BeforeEdit(ByVal Row As Long, ByVal Col As Long, Cancel As Boolean)
    If Col = 1 Then vsFlexArray1.ComboList = "Red|Green|Blue|Other"

End Sub

Private Sub vsFlexArray1_Click()
    Call vsFlexArray1_BeforeEdit(vsFlexArray1.Row, vsFlexArray1.Col, False)
 
End Sub

0
manne
Asked:
manne
  • 2
1 Solution
 
clifABBCommented:
Keep the code in BeforeEdit, but place the following code in the FlexArray's click event:

Private Sub vsFlexArray1_Click()
    If vsFlexArray1.Col = 1 Then vsFlexArray1.EditCell
End Sub


I like VSFlex.  It's lightweight, easy to use, and they have great tech support (when you can get through).
0
 
clifABBCommented:
Oh, by the way, the reason your code wasn't working is because
Combolist only works within BeforeEdit *and* when the cell is in edit mode.
0
 
manneAuthor Commented:
I short and good answer, thank you!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now