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 (2.4k 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
wellsr Q&A is the VBA and Python programming community that rewards you for learning how to code.

Getting Started
Register
VBA Cheat Sheets (On Sale Now)

Earn free prizes for asking VBA and Python questions and for answering questions asked by others in our community.

What makes us different?
Our points system rewards you with a chance for free gifts based on the quality of your questions and answers. All you have to do is post and you could get rewarded, like these members:

runfunke $10 Amazon Gift Card
coolag $10 Amazon Gift Card
Siew Hun $10 Amazon Gift Card

So, why don't you join us? It really is an encouraging way to motivate members in our VBA and Python community.

Register

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

...