Setting a random string generator excel 2010 pattern

Asked By 30 points N/A Posted on -
qa-featured

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!

SHARE
Answered By 5 points N/A #149864

Setting a random string generator excel 2010 pattern

qa-featured

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.

Related Questions