Two If Then Statement not working - Excel VBA

[eemiller1997]

Most of my If Then Statements are working except two.

The first If Then Statement is the following. (The 'Intvw_Type" is a combobox with an option of Internal/Informal.)

Please Login or Register  to view this content.

The other If Then Statement is the following, which is saying if those two answers are identicle, then put ****** AH:

Please Login or Register  to view this content.

Both parts of those two IF Then Statements are working, as you can see in the attached screenshot.

Weekly Visitor's List IF Then Statement.jpg

The next part that happens is within this code when the final out put is printed it is placed in a specific spot on a form that is printed out:

Please Login or Register  to view this content.

But, this part of the code doesn't seem to be working, but I've checked everything. The cells N42, N33, and N34 are correct. The 33, 34, and 35 are also correct, but the form prints without the correct ****** in N42, N33, and N34.

I have other If Then Statements that do the same thing, add ****** to their respective cells, however, these two above are not working. Any ideas?

[Norie]

Have you stepped through the code with F8?

If you do that you can check the values being used in the code.

[eemiller1997]

I've not heard of that before. This is new to me. How do I step through the code with F8?

[Norie]

Try this.

Select the first if statement, press F9.

That creates a breakpoint.

Now do whatever you have to do for the If statements to get executed.

If you do that the code should then halt and you can step though each line with F8.

[eemiller1997]

I'm not getting this. It seems like it should be straight forward but it jumps from this to that and form that to this and it's not making any sense. I know the problem exists somewhere in the second part since the correct answers are placed in the CandidateData worksheet, but are not being transferred to the form.

[Norie]

What jumps from 'that to this'?

[eemiller1997]

Well, I have my curser at the beginning of the line of code I want to test and press F8 and it takes me to Private Sub UserForm_Initialize () each and every time. then, F8 just takes me line thru line for that set of code and then brings up my form....

[eemiller1997]

Here is the attached UserForm, maybe this will help shed some light. I've been wracking my brain over this.

ComboBoxPrintBox_TroublesV9.xlsm

[Norie]

You start the userform as you normally would.

Then you do what you have to for the If statements to be executed.

The code should then 'break' where you set the breakpoint.

It's from that point you step through with F8.

[eemiller1997]

I haven't been able to figure this out. I'm completely stumped and pulling my hair out on this one. I've double, triple, and quadriple checked everything.

[Norie]

Did you step through the code?

[eemiller1997]

That's what I've been pulling my hair just trying to figure out.

[Norie]

Do you mean you haven't been able to step through the code?

Where did you add breakpoints?

[eemiller1997]

I have not been able to step through the code and get any valuable information.

Breakpoints.jpg

[Norie]

Where do you have this code?

[eemiller1997]

It's under the print userform. Because the if then statement is working and doing it's job, it's the part from there to where it goes onto the form where the problem is.

[Norie]

Those 2 if statements don't look to me as though they belong in the print form.

The reason I say that is because I think they are actually meant to be writing to the candidate sheet.

[eemiller1997]

The two if then statements do write to the candidatedata sheet, and that is the part that works. The part that isn't working is when the print button places the answers from the candidatedata sheet, they don't carry over to the candidateform sheet when printed.

[Norie]

So the If statements work perfectly fine?

Is it this code that doesn't work?

Please Login or Register  to view this content.

[Norie]

The code is working.

On CandidateForm goto N33, N34 and N33 and change the formatting so you can actually see what's in the cells.

[eemiller1997]

Oh my gosh! Seriously! I've been wracking my brain over that, too! Sometimes the simplist things get overthought. Thank you so much! This is crazy and embarrasing. Ugh! Well, it's not because I didn't know what I was doing, huh!? .... I hang my head in shame....

[Norie]

No problem.

Might be worth going through that candidate form checking everything will be visible.

[eemiller1997]

Good Idea. I have no idea how and when that formatting changed, but I'm going to go through and fix it all now