Associate a picture with a random number

[GeeBDee]

Hi

Is it possible to associate (show) a picture to a number that is radomly chosen? Could this be done by macro, or just a formula within a cell. This is for display purposes in a spreadsheet

Thank you
Grant

 

[Worf]

Hi Grant

See if this helps:

Sub ShowRandom()
Dim i%, upperv%
upperv = ActiveSheet.Pictures.Count
Static rndmzed As Boolean
If Not rndmzed Then
    Randomize
    rndmzed = True
End If
For i = 1 To upperv
    ActiveSheet.Pictures(i).Visible = 0                     ' all invisible
Next
ActiveSheet.Pictures(Int(upperv * Rnd + 1)).Visible = 1     ' show one random image
End Sub

 

[SpreedsheetCrusader]

bro

i already have posted additional stuff last week at your original thread where you requested that.

i showed in length how can you associate the pics with the random number generated by the macro through in cell formulas and picture links

check it out


http://www.mrexcel.com/forum/excel-questions/909365-macro-randomly-choose-numbers.html

and Like

 

[GeeBDee]

Hi Spreadsheetcrusader

I am really sorry, Yes I do have that coding and it worked well for what I required. Please accept my apologies

G