Vba - generate random alphanumeric strings based on user input

[SWETHAKHATRI88]

Hi all. I am looking to create a VBA which generates alphanumeric values( numbers and caps letters) based on user input. For example if user says 15, 15 random alphanumeric values need to be populated with a max length of 35 in column A. Column B should populate 15 random alphanumeric values with a max length of 10 and column c should populate 15 random values. I can achieve this with formulas but vba is preferable. Can someone help pls
The values should start from A2

I started the code

Dim myvalue as Variant
myValue = InputBox("How much test data is required")

 

[DanteAmor]

For example if user says 15

You can give an example of what you expect as a result.

Use xl2bb tool or an image.