0 votes
in VBA by Beginner (2 points)
Userform to maintain Excel table by ComboBox

Want to use this and VBA to edit, add and delete records

 

What are issues?

1 Answer

0 votes
by Super Expert (3.2k points)
The logic for controlling the table data addition, deletion and editing can get complex since there can be so many options, but it's certainly possible. As a matter of fact, I've made a couple spreadsheets like this over the years where data entry and maintenance are entirely controlled by UserForm fields.

There aren't really any unique issues to worry about. The only downside is the data entry will be slower since the user will have to navigate the UserForm fields. To maintain the integrity of the sheets, you'll need to remember to unprotect them at the start of your macros and protect them again at the end. You'll also need to remember to protect them in any error handling routines you have in your macro so they don't accidentally get left unprotected if the user encounters a runtime error.

Welcome to wellsr Q&A
Ask any questions you have about VBA and Python and our community will help answer them. wellsr Q&A is the standalone question and answer platform for wellsr.com. If you have a question about one of our specific tutorials, please include a link back to the tutorial.

Getting Started
Register
VBA Cheat Sheets (On Sale Now)

Looking for something else? Hire our team directly through ourVBA Help page, instead.

For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.

...