NUMBER GENERATOR HELP NEEDED

Hot Topic

If... GoTo
Run-time error '1004' in import macro
is weekday
Access 2000 RecordSet Sort problem
problem printing with IE 6.0.2 (hopefully resolved in IE 7)
Windows XP Thread Starvation
personalized command bar disappears when minimizing excel
iexplore.exe - Application Error
[ADO Excel] How to use ADO retrieve Excel Worksheet name and some information
append excel data to text file

Microsoft ISV

Do we need to have a strong name for webparts?
CRM 3.0 : Changed Contact view under customization but CRM do not reflect
Problem passing a range as argument
iexplore.exe - Application Error
SELECT syntax in VBA for retrieving information
Placing data in matrix
converting text to Hours Minutes and Seconds
Office Communicator 2005 sign-in name, auto populate after install somehow?
Solved - Help with Excel VBA Code
MS Office document and image writer print driver

NUMBER GENERATOR HELP NEEDED

Hi, I'm looking for a letters generator from a to g. Or a numbers generator. 1 to 9. I have a scoring system for a horseshoe game I created in excel 2007 beta. I need the letters in column d3 to d13 to update once a round is completed. Which happens ok. But once a team is eliminated. I dont want a letter assined to the cell. If anyone could take a look will understand my issue.

I will email you the workbook if you think you can help me out with this. I don't no vba yet but am trying to understand it. my email is trobert672@comcast.net

Answer this question

NUMBER GENERATOR HELP NEEDED

  • Vimal_Rupera

    Hi Derek, I try it out but I dont no what i'm really doing. I could send you the file to look at if needed Thanks again for your response Tom

  • vadex

    How do you plan to map a set of nine integers to a set of seven letters



  • comtel_95

    Hi,

    To produce random integers in a given range, use this formula:

    Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
     
        Dim upperbound As Integer
        upperbound = 9
        Dim lowerbound As Integer
        lowerbound = 1
            
        Dim random As Integer
        random = Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
        MsgBox random


  • abcdefgqwerty2

    I'm sorry mate I don't have any time at the moment to look at the file.

    You know what needs to be done so thats a start. Store your letters in an array and use the random number to index an element in the array. Thats pretty straight forward. Have a look at arrays in the help. Post again if you get stuck and someone will help you out.



  • NUMBER GENERATOR HELP NEEDED
Answer this question