Plan De Cuentas Contables Venezuela Excel Vba [patched] Access

VBA logic automatically applies the coding hierarchy (e.g., 1 digit for element, 2 for group, 3 for major account, 5 for sub-account). Dynamic Data Validation and Duplicate Prevention

Sub CrearListaCuentas() Dim wsPlan As Worksheet, wsEntradas As Worksheet Dim ultFila As Long Set wsPlan = Sheets("PlanCuentas") Set wsEntradas = Sheets("Asientos") ultFila = wsPlan.Cells(Rows.Count, 1).End(xlUp).Row With wsEntradas.Range("A2:A1000").Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _ Formula1:="=" & wsPlan.Range("A2:A" & ultFila).Address(, , , True) End With plan de cuentas contables venezuela excel vba

The Ledger of Last Resort

Function ValidarCuenta(codigo As String) As Boolean If dictCuentas.exists(codigo) Then ValidarCuenta = True Else ValidarCuenta = False MsgBox "Cuenta " & codigo & " no existe en el Plan de Cuentas." End If End Function VBA logic automatically applies the coding hierarchy (e