Here goes...
MY PLAN:
1. I have a form with multiple text boxes (8 lines total; each line with it's own textbox and multiple label captions)
2. Not all textboxes are required to have a value entered.
3. When user is finished entering values in their selected textboxes, the cmdAddbutton they click will transfer the form label captions AND the text box entry to a spreadsheet.
MY PROBLEM:
When the user clicks the cmdAddbutton, the lines with textboxes that had no data entered into them, are still transferring over to the spreadsheet (labels and null textbox values)
MY HOPE:
When the cmdaddbutton is clicked, I only need the line items that have user input in the textbox transferred to the spreadsheet (and not include labels and null textbox values). All my research keeps pointing toward a CLASS MODULE where I can set properties and methods to control all TextBoxes within a form. . I have no idea how to do this.
MY CODE:
Can someone provide any guidance or point me in the right direction? I've researched J. Walenbachs VBA power programming and though helpful, my VBA prowess just isn't up to speed yet.
Anxiously waiting in Cali.
Best
pt
Bookmarks