TextBox to Excel

[Xystus777]

Yep, I'll check again though, hah.

[Xav]

It sounds strange that the particular line of code was the problem. Little can go wrong with it, you are just assigning a value to a variable from a textbox.

[Xystus777]

I know it, I'm confused too! Hah. There's obviously something wrong somewhere else that's throwing it out at that point. I don't know.

[Xav]

Try some old-fashioned debugging.

Inspect the textbox's contents via the Immediate window.

[Xystus777]

What does this mean, this didn't show up before. But in my warning section when I build, it says:

Warning 1 Field 'T_Numbers.Form2.xlWB' is never assigned to, and will always have its default value null

Warning 2 Field 'T_Numbers.Form2.xlWS' is never assigned to, and will always have its default value null

[Xav]

It means you never give that variable a value with your current code, so the variable is pointless at the moment.

[Xystus777]

Alright, I'll look into it. I'm at home now, I'll work on it tomorrow at work. Thanks for all of your help. I'm sure i'll be posting again tomorrow.

[Xav]

OK. I will probably be here.