Forum Discussion

AShell23's avatar
AShell23
Copper Contributor
May 17, 2023

excel database

I hope this isn't confusing.  I saw a while ago an Excel workbook with a table to keep track of "errors" from reviewing documents.  One of the sheets was set up so you could enter data and "submit" a...
Charting
excel
Formulas and Functions
SnowMan55's avatar
SnowMan55
Bronze Contributor
May 18, 2023

AShell23  What you are trying to do is in part what user porcupine_racer was working on in the post I'm having trouble with my VBA code for an entry form to a table.  The code there or the attached workbook (macro-enabled) here should give you a start.

 

Reminder: Macro-enabled workbooks carry a higher risk of malware: e.g., Microsoft Excel Encryption Vulnerability Paves the Way for Malware and Emotet Now Spreading Through Malicious Excel Files, besides the usual data security issues.  (Do not open a file that you do not trust!  For those that you do, scan them anyway, for viruses/trojans/ransomware; handle them on an isolated computer if possible; open read-only; review all the code before you enable editing.  But do not trust password-protected .zip files!)

 

Resources