DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

stumped random character generator

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Aug 2008

Posts: 9

Reputation: herephishy is an unknown quantity at this point

Solved Threads: 0

herephishy herephishy is offline

Offline

Newbie Poster

stumped random character generator

Aug 9th, 2008

VBA so that each click generates a random character between A and Z in cell A1, and the number is displayed with a random font size in the range of 16 to 24 points.

can anyone help me out??

•

Join Date: Jan 2008

Posts: 65

Reputation: bushman_222 is an unknown quantity at this point

Solved Threads: 4

bushman_222 bushman_222 is offline

Offline

Junior Poster in Training

Re: stumped random character generator

Aug 9th, 2008

try using the ascii character map, ie chr(65) is A

find the table below
http://www.asciitable.com/

then use then randomize, and then the rand command to be able to pick a random character between the range that you require.

By memory it is rand(high-low)-low
try the below. (there might be a couple of errors as I haven't done VBA for a while)

 Help with Code Tags 
 vb Syntax (Toggle Plain Text) 
 
  randomize
  randomcharacter = rand(90 -65)-65
  range("A1") = chr(randomcharacter)
  randomize
  randomcharacter = rand(90 -65)-65
  range("A1") = chr(randomcharacter)