Setting a random string generator excel 2010 pattern

Asked By damon healy 30 points N/A Posted on - 05/04/2013

Hello there, I prefer to specify the pattern for my codes. How am I going to set a random string generator excel 2010 pattern? I want to add a pattern that we’ve used before but I have already forgotten how to go about it in excel. I’m not so savvy with it and I got confused with the options. Please help!

• Status: Open
• Question Views: 840
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Holloway Hively 5 points N/A #149864

Setting a random string generator excel 2010 pattern

Hi Damon,

Though your specification isn't quite complete and confusing, I tried to create a simple random string generator that might aid you. You can create a random string generator in Excel by using a Visual Basic Application. You may check the attached Excel. Once you open the file, there two actions that the user should do:

• First, the user should input the number of string that he wanted to generate in cell B2.
• Second click the "Generate!" button. This will allow you generate the new string. The output will be displayed in cell B3.

You may check the codes I embed on the "Generate!" button by clicking Alt + F11 on your keyboard. Hopefully I help you with your inquiry.

About Holloway Hively

Questions
2

Answers
102

Best Answers
45

• Vote Up 0 Vote Down

• Posted on - 05/16/2013
• Question Category: MS Excel