Generate random Code consist of number and letter using VBA code

Dear All
i would like to use VBA code in excel to generate random Alphanumric in range of cell for example A1:A19
or for another case
A1 : C12

i search on internet and found code but it work with access and find its very useful to use it
as the following

HTML Code: 

i will be thankful if we can create something like this in userform in excel that enable select width of random needed like in attached photo but instead to result will put range of cell needed

here the design for user-form need to make the code

If you have no rule in order.

Please Login or Register  to view this content.

What you mean by no rules in order

Rule of random string.

and what about sheet list or give option to create new sheet or workbook

i want to generate number plus alphabetical (capital and small)

Your title says

Generate random Code consist of number and letter using VBA code

yes number and letter

let me know if there is any wrong that can i correct it

or if you want to make new thread

You need to explain what you are really trying to do.

ok
i want to generate random alphanumeric consist of number and letter (capital and small ) with different length
and i get this idea to make userform to give me many flexibility to choice
1- that enable me to select length of random generated
2- enable to select range of the cell
3- select the sheet name that i will generate this data from sheet list
4- give me another option to create new sheet (with box to enter name of new sheet ) or give option to create new workbook
that all
what i need because i will use this for generate code for many and will take this for printing with another software
hope you now understand me

See if this is how you wanted.

its working but its give me only one option new sheet without give me choice to enter the name of new sheet
because i will generate lot of sheet for different work
also not allow to enter the range just must select ( the reason want to enter the range is i will generate for lot of cells )

Try this one

............................

dear jindon
many thanks for your help and your solution