I really like this Macro Express program. It is the answer to my problem. I have one person sit down at the computer and type for a couple hours a day for 2 or 3 days a month. Needless to say this program will cut down on my computer time. The only problem is, I know so little about the program, how to write it and how it works, that the questions I ask and my explanation of what I need, is translated by the expert programmer (YOU) to something I didn’t foresee.
I copy/paste the info of your latest revision into Macro Express and the program does exactly what you said it would. I pick a first letter, I pick a second letter, I input a starting number, I choose how many times I want the number to repeat and presto, excel is full of numbers. Excellent job on the program. It works perfectly, it works just as you said it would and you are to be commended on your Macro skills (I have a sneaking suspicion there is voodoo involved but can’t prove it). The program works great BUT…
Bare with me here. I will try to explain exactly what I need. Keep in mind that any fumbling and confusion is my fault. I know so little about this Macro program that I don’t know how to explain what I need and make it clear to someone that is very good with the program. Ever take a test in school and come to a question that you don’t understand? Well that’s where I am. Not only do I not know the answer but the question itself makes me confused! OK, here is what I need.
I need to choose the first letter. (You have that)
I need to choose the second letter. (You have that)
I need to type in the first set of 8 numbers. (You have that)
When I hit the macro key, I need that letter/number combination to print to the screen. Do nothing else, just print to the screen.
Then I want to manually hit return which will cause the curser drop to the next cell down. (Excel will auto do this movement when enter is pressed)
Then I want to hit the macro key again and have it print the next number/letter combination in line (without having to repeat choosing the letters and number I want) and have it print that to the cell and wait for me to hit enter so it will move to the next line.
I need the program to do this as many times as I need (it will vary and you need not ask me how many letter number combos I need) until I have enough numbers then I can hit disable and shut the program off when I reach the number of consecutive numbered cells I need.
As the program is written now, it asks me for, and prints any number of consecutive serial numbers I want but its prints them all at once when I paste. I don’t want to have to use paste; it slows everything down a whole bunch. I need it to stop with one number/letter combination until I hit return then when I hit the hot key again, print the next number/letter in the sequence and wait for me to press return again. Also I would like to choose the first letter and second letter and the starting serial number only once for each session regardless of how long that session (how ever many consecutive numbers I need) lasts.
Here is where my lack of program knowledge comes into play….. I don’t know how to ask for exactly what I want. Hmmmmmm…..
Say I want to print 11 numbers to the excel cells. I choose the first letter call it A, I choose the second letter call it B, I choose the starting number lets call it 00000001.
When I press the hot key I would like it to print A00000001B in the first cell and then have the program stop and wait. I will then manually press enter and this will shift the curser down to the next cell.
Then I would like to press the hot key again (without having to go thru the first letter, second letter, number selection routine over again or go thru the paste routine) and have it print the next combo in line which would be A00000002B.
Again I manually hit enter, the curser drops down to the next cell and when I press the hot key again the program will print A00000003B and wait. I will then press enter to move the curser down in excel.
When I come to the end of my secession which in this case would be cell number 11 containing serial number A00000012B, I would just then choose disable Macro Express from the menu and end the program.
To recap, this is a stand alone program, used to generate consecutive serial numbers of my choosing, (regardless of how many I need), each hot key press will print the next in line number/letter combo and will stop. After I press enter I will press the hot key again which will print the next in line letter/number combo. I will repeat the hotkey/manual enter routine until I come to the end and then manually shut off the program. You do not need to add a subroutine to end the program or any other routine to make what you think would be improvements. I get confused by improvements! A stripped down, bare bones working program with minimum fuss is better than a highly refined polished production. Who knows, some day if the sun rises in the WEST I just might understand this thing.
I apologize for being receptive in my statements and maybe sounding like I am giving instructions to a child. Matter of fact I really am talking to a child but the child is ME. I feel I must write this way to get everything straight in my mind so I have at least a 1% chance of explaining to you what I need.
Thanks for your time.