Any idea how to sort a MSFlexGrid column of dates that are in the format of mm/dd/yyyy. The problem occures when you have single character days and 2 character days in the same column. I know I could change the format of the data, but it is formatted by another program and it is unliklely it will change.
Can you change the format of the cells?
Private Sub sortdate(colno As Long)
For i = 0 To MSFlexGrid1.Rows - 1
MSFlexGrid1.Row = i
MSFlexGrid1.col = colno
mydate = Format(MSFlexGrid1.Text,
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC. I didn't post completely correct code o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.