I have 3 subs/functions I created so that I'm not re-writing the code to take a sql statement, and add it to a listview.

The 3 subs are

  1. udfFormatListView
  2. udfCreateListViewHeaders
  3. udfPopulateListview


vb Code:
  1. udfFormatListView(ByRef MyListView as Listview)
  2. udfCreateListViewHeaders(ByRef MyListView as ListView, ByVal strSQL as String, Optional ByVal HideFirst As Boolean = True) AS Long
  3. udfPopulateListview(ByVal MyListView As ListView, ByVal strSQL As String) As Long

I put them in a class, but by themselves, it seems kind of a waste of using a class.

Should I just use a module instead? What else could I add to the class to make it worth being in a class?

I was going to include constant values to define types of errors that could be received back from the functions.

When I am complete I was going to submit the class to possibly be added to the Codebank.