Hi
I am new to VBA. I know a few basic syntax.
I have the following code.
1) There are many If statements. But everything checks the same condition. Can I reduce the code, like using a for loop or something?
2) I also intend to add a "Clear Values" button, which will clear all values without closing the userform. How can I clear all values? For eg, if I press clear values button, I need all textboxes to be cleared (empty). I could do textbox1.text = ""
textbox2.text = ""
textbox3.text = ""
Is ther an easier method.
3) any good( and free) links to learn VBA(beginners)
Private Sub CommandButton1_Click()
Please Login or Register to view this content.
Bookmarks