Private Sub btnSave_Click() Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Invoices") '--- Basic validation ------------------------------------------------- If Trim(txtNo.Value) = "" Then MsgBox "Invoice number required.", vbExclamation Exit Sub End If '--- Compute total ---------------------------------------------------- Dim amt As Double, taxPct As Double, taxAmt As Double, total As Double amt = CDbl(Val(txtAmt.Value)) taxPct = CDbl(Val(txtTax.Value)) / 100 taxAmt = amt * taxPct total = amt + taxAmt txtTotal.Value = Format(total, "0.00") '--- Find existing row (edit) or append new ---------------------------- Dim r As Range, exists As Boolean Set r = ws.Columns("B").Find(What:=Trim(txtNo.Value), LookIn:=xlValues, LookAt:=xlWhole) If Not r Is Nothing Then exists = True Set r = r.EntireRow Else exists = False Set r = ws.Cells(ws.Rows.Count, 1).End(xlUp).Offset(1, 0) ' next empty row End If '--- Write data -------------------------------------------------------- r.Cells(1, 1).Value = IIf(IsDate(txtDate.Value), CDate(txtDate.Value
Private Sub btnCancel_Click() Unload Me End Sub invoice manager for excel activation key
You can drop the code into a new workbook, customize the worksheet layout to suit your business, and then distribute the file together with a list of valid keys (or a single key you generate for each customer). This implementation is not meant to be a high‑security DRM system – VBA can be read and altered by a determined user. It is, however, more than enough for basic “you‑must‑enter‑a‑key before you can use the tool” scenarios typical for internal tools, small‑business add‑ins, or prototype deployments. 1️⃣ What the solution does | Feature | Description | |--------|-------------| | Invoice entry form | A user‑form ( frmInvoice ) lets you capture the main invoice fields (Date, Number, Customer, Items, Amount, Tax, Total). | | Invoice list | All entered invoices are stored in a hidden worksheet called Invoices . | | Search / edit | A second form ( frmSearch ) lets you locate an invoice by number and optionally edit it. | | Activation‑key check | When the workbook opens, a modal dialog asks for a key. The key is validated against a simple algorithm (hash‑based) and, if valid, the rest of the UI becomes usable. Invalid or missing keys keep the workbook locked. | | Key management | All valid keys are stored (obfuscated) in the hidden sheet KeyStore – you can add/remove keys without touching the code. | | Lock‑down | The VBA project itself is password‑protected (you set it yourself) and the key‑check disables the ribbon items that launch the forms until a valid key is entered. | 2️⃣ Workbook layout (what you need to create) | Sheet name | Visibility | Purpose | |------------|------------|---------| | Invoices | Very hidden (via VBA) | Stores each invoice as one row. Columns: A:Date , B:Number , C:Customer , D:Items , E:Amount , F:Tax , G:Total . | | KeyStore | Very hidden | Column A holds the obfuscated (base‑64‑encoded) list of valid keys. | | Dashboard | Visible (optional) | A simple front‑page where you can place two buttons: “New Invoice” and “Search Invoice” . The buttons are wired to the macros ShowInvoiceForm and ShowSearchForm . | Tip: If you prefer a clean workbook, you can delete any extra sheets. The code only references the three above. 3️⃣ VBA code – copy‑paste it into a standard module (e.g., modInvoiceMgr ) Option Explicit Private Sub btnSave_Click() Dim ws As Worksheet Set