Searching this forum, I found the below code to generate a list of numbers in random order using vba.
I'm trying to adapt this code in order to add a new variable (x), so that the upperbound value of array V is the value of this variable (x).
Sub Demo1()
Dim x, V, L&, R&, S
x =...
Help me please. I would like to know the possible probability, forecast, and trend. If you are given 2 possible outcome with atleast 1-60 given outcomes. For insctance, if you have 100 ballpens, and the only colors are BLUE and RED. then you want to know the possible color you would pick next...
Hello there, and thank you in advance for your help.
I've been using the following code that I got in this site:
https://www.mrexcel.com/board/threads/extracting-number-from-a-range-randomly.1158430/page-3#post-5788613
I would like to say thank you for the code to @Peter_SSs. The code is...
Hi there,
I'm looking for a macro which generate an 8 digit hexa number on a given input numbers. But before generate a random hexa-number, check if particular input is already in a cell (for example row 12) in column A, corresponding to that cell value (cell 12)in column B will be added in...
Hi,
I was hoping to use vba to generate a random code that will contain both letters and numbers, being 9 characters long.
Its going to be a part of a userform so the random code generated will populate a textbox within the userform.
Many thanks in advance to any help you can give,
Mike
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.