Stupid Input Box Error 2015

Hey Guys ! The code is so simple (I thought...) but it isn't even displaying the input box, and I've never encountered that. I have some code before the issue to give some variables names:

Please Login or Register  to view this content.

and then that works fine, but when I try to use:

Please Login or Register  to view this content.

It doesn't display the box and just says that Prelimorfinal = "Error 2015" I'm still really new to this stuff and I thought I would try to break down the code into multiple lines so it's prettier and I undid that as an experiment but that doesn't appear to be the problem.

I'm pretty sure I made a dumb error. But I've tried Googling this and I just have no idea what went wrong.

(The code is posted virtually in entirety, I omitted a line that checks for worksheets.count = 6 at the very top, and I split it up because I'm trying to identify that the top portion works fine and the problem is 'only' in the bottom portion)

i've just tested that code for the input box on my pc and it seems to work fine, could you post the full code maybe?

Andy

okay, for me once i got the code to run (had to change some missing goto lines, but i assumed theyre all fine for you) then the code seemed to run fine. although i got errors on ActiveWorkbook.Worksheets(prelimorfinal).Range("A1").Select where it wouldn't select the cell withotu activating the sheet first (but i didnt think that should be a problem, i miust admit my excel does seem to be playing up a little bit.)

Either way that input box SHOULD work, doesnt seem to be anything wrong with the code.

Have you tried stepping into the code and running it line by line?

Andy

Ahh sorry about the goto lines. I'm still learning fourm etiquette. I probably need to suck it up and actually post the whole POS -- I just feel bad about posting entire streams of code. I code so poorly that things are usually 10x the length they need to be. So I omitted my "error box" which is where those goto's point. I'm really ghetto. And I think people will laugh at my "error box"

Ok I copied JUST the input box to a new module and took out all other code and it works. It must be a problem with my use of the variables once they were given values...

That code works for me also, is there anything with any of your sheet names that could cause the problem.

you may also want to adjust the code slightly to

Please Login or Register  to view this content.

its always best to avoid select staments , however i wouldnt have thought this would fix the code

UGH! I tried to not use select statements to begin with but I couldn't get the object.property thing correct for assigning sheet names. I replaced the old code with what you wrote, and it works great for defining the variables but I still get the same error as before.

Where exactly do you get the error?

What exactly is the code meant to do?

The error is that the variable, instead of being defined via the users input into the input box it literally gets defined as "Error 2015" which is USELESS to me.

The code is designed to use the excel's text to columns feature depending on the length of a string size.

The code won't work because Application.Len("A1") will always return 2.

Give this code a try.

It's really just a kind of guess based on the code you posted, I think if we could have a workbook to work with it might help.

Please Login or Register  to view this content.

OH MY GOD HOW DO YOU PEOPLE GET SO GOOD AT THIS ! lol. Yes. Yes that does precisely what I want it to. But. The problem is. I suck. And I don't understand why it's working.

OK I'll switch out the old crappy code for this newer awesome code and I'll try to learn it thanks so much !

What has been entered for prelimorfinal?

In the input box I put "2" -- without quotes, obviously

And when I hover the mouse over 'prelimorfinal' it does say: "2"

With quotes, which is normal I'm pretty sure.

This is my mistake, and I'm surprised it hasn't happened before.

Anwyay it should be this.

Please Login or Register  to view this content.

Perfect perfect perfect! The only thing I changed with your code was:

Please Login or Register  to view this content.

You had 3's there. And it shoved the information three rows below and turned into fajibblejabble. I am so thrilled with your help, this is astounding. !! YAY !! You have made my life so much easier and I've been able to learn a lot from this.

The reason I had a 3 there was because in the original code you were splitting A1 but you'd specified the destination as A4.

I did think it was a bit strange, but it was your code so who am I to say.

PS You don't need the Offset thing at all.