HELP: If (A And B And C...) Then Else... Always doing Else

**ReedDOT** · 05-08-2013, 03:12 PM

Hey Guys,

I am using textboxes in a userform to write data in excel.
The last cell is set up with prewritten text if values are entered in certain textboxes of the user form.

I want the last cell to be blank if nothing is entered in any of the 5 textboxes. Yet if something is entered in any one of the 5 textboxes then I want the last cell to be filled with data.

My If/Then/Else code is ignoring my If/Then and executing the Else no matter what.

Here is the code

Please Login or Register  to view this content.

Please Advise

**AndyLitch** · 05-09-2013, 01:51 AM

It'll only execute the IF when ALL the named textboxes are empty. For whatever reason this isn't ever happening.

**ReedDOT** · 05-09-2013, 08:25 AM

Right. That is what I want it to do.
But I could run it without ever putting my cursor in any of those textboxes and it will still do my else.
It may be something I am overlooking in the code. Even if I put an ' on the last 4 conditions of the IF and try to run it with just the 1st condition, it still does the ELSE.

**ReedDOT** · 05-09-2013, 08:30 AM

I do not have a UserForm_Initialize setup. Maybe I will try that so that my textbox.values="" at the beginning.

**AndyLitch** · 05-09-2013, 08:38 AM

Yeah ... Might be worth trying as a test...

**ReedDOT** · 05-09-2013, 08:59 AM

OK, so I am about to incorporate a personal rule: "Try troubleshooting the issues for 48hrs before getting ExcelForum involved."

As I ran my code just now, I noticed that I had this "problem code" in my NextButton_Click. Yet I was testing the code by clicking my FinishButton, which I had not input this If/Then/Else condition into that sub yet. I knew it had to be something simple like that because the condition was written correctly. Anyway, it works now.

Sorry for the trouble and thanks for responding AndyLitch.

Until next time....