Forum Discussion
What would you do? User needs to generate a random number and ideally not leave the worksheet
Hey Gang! I have a spreadsheet (see below) that requires the user to generate unique identifiers for the PCODE row and the BUNDLE IDENTIFIER row. What I have them doing is clicking on another worksh...
You might replace the lines
Set genPCODEBUNDLEID = ThisWorkbook.Sheets("Generate_PCODE_BUNDLEID")
Set cell = genPCODEBUNDLEID.Range("D9")
in GeneratePCODE_Click with
Set cell = ActiveCell
and assign the GeneratePCODE_Click macro to a custom keyboard shortcut.
Do the same for GenerateBUNDLEID_Click.
Thanks I will give that a try