Macros Boxes that switch to next box

**dextras** · 06-22-2009, 08:11 AM

Heading didn't make much sense but not sure how to describe it. What I need is this. I have set up a macro as shown in this thread but I need to be able to have some of the boxes do the following. Instead of coming up with the question and then you put in the answer I need a thing that comes up with 2 boxes and when you type in 3 numbers then it switches to the next box. As well, in between these 2 numbers a "|" needs to be placed.

So You would type say 410 in the box and then it switches to the next box that can be seen in the same pop up box (like tab's over) and then you type say 662 and then you hit ok, and it insert "410|662" (without "") into the designated cell. At the moment this is my code for the macro:

Please Login or Register  to view this content.

The second input box is the one it's for.

Here's an example of what I mean: http://tribalwarsmap.com/traveltimes?world=1
Except, when you type the first 3 digits in at the top it would switch to the next box to the right. The pop up would only have 2 boxes to put data into though, not 4.

ty for any help in advance

**dextras** · 06-22-2009, 05:46 PM

BUMP. Anyone know how this can be done?

**jaslake** · 06-23-2009, 12:03 AM

I'm not sure what you're trying to accomplish but the macros in this workbook will allow you to put the value 410|662 (or any other value) in whatever cell you wish. See the attached.

Hope this helps.

J

**dextras** · 06-23-2009, 02:46 AM

That does what i need. How can I incorporate that into:

Please Login or Register  to view this content.

For the second vresponse

**dextras** · 06-23-2009, 04:32 AM

For this moment in time I'm not gonna bother with this so nevermind. ty anyway

**jaslake** · 06-24-2009, 02:15 PM

When you get back to it, I've attached a workbook that incorporates the above in your code. I didn't want to reverse engineer your original code to make it run on my machine so I eliminated some of your bells and whistles. You can put them back in.

You can eliminate your user input forms altogether by incorporating the "Enter your village name" prompt as another box in the UserForm1.

Hope this helps.

J