Posted 19 April 2022, 7:14 am EST
Hello.
Unfortunately, our ActiveX Controls are intended to be used by VB6 or C++ developers in Visual Studio.
https://www.grapecity.com/componentone-system-requirements#activex
Access VBA is not a supported environment and thus we don’t have any samples or documentation regarding using vsFlexGrid in VBA.
That said, vsFlexGrid has a column data type of FlexDTDate. This is mostly to allow proper sorting or filtering of date information (otherwise it gets treated as strings).
https://help.grapecity.com/componentone/NetHelp/vsflexgrid8/coldatatypeproperty.html
Also, in VB6, there is a sample included with the studio called “DTPick” which shows how to invoke a DateTime editor when editing a cell in vsFlexGrid.
https://help.grapecity.com/componentone/NetHelp/vsflexgrid8/visualbasicsamples.html
If you don’t have Visual Studio 6, you probably can’t open the sample (It should be in your documents folder C:\Users[USERNAME]\Documents\ComponentOne Samples\ActiveX\VS FlexGrid Pro 8.0\Vb\DTPick) but you can open the form1.frm in a notepad and about halfway down you can see the VB6 code used for the KeyDown, StartEdit and other events they use to make it work. I can’t say for sure if the same would working VBA because we’ve never tested it since it’s not a support environment but it might be worth a try.
Thank you.
Andy