Creating VBA code to create random number and highlight cell result

[Cquake]

I am looking for some help to create the correct VBA code to use with my ActiveX Button to generate a random number between 1-24 ( These numbers will be in cells H4:H28) that would then highlight the corrosponding cell (using a light red background with bold black numbers) in the matching random number data result generated in cells I4:I28. Can this be done as I have looked around but have not found the answer to this. Any help would be appreciated.

Thanks

 

[James006]

Hello,

Before getting to VBA ... make sure to clarify your objective ...

Generating a random number could be done with

[COLOR=#2C2C2D][FONT=PT Serif]=RANDBETWEEN(1,24) [/FONT][/COLOR]

But your text suggest you would need in fact 24 numbers (between 1 and 24) randomly distributed ... with NO DUPLICATES ...

The issue of highlighting any cell ... can always be taken of ... afterwards ...

Thanks for clarifying ... :wink:

 

[Peter_SSs]

I'm not clear on the requirement. Could you post a sample set of data and results and explain again in relation to that sample?

 

[Cquake]

Hello,

Before getting to VBA ... make sure to clarify your objective ...

Generating a random number could be done with

[COLOR=#2C2C2D][FONT=PT Serif]=RANDBETWEEN(1,24) [/FONT][/COLOR]

But your text suggest you would need in fact 24 numbers (between 1 and 24) randomly distributed ... with NO DUPLICATES ...

The issue of highlighting any cell ... can always be taken of ... afterwards ...

Thanks for clarifying ... :wink:

Thanks for replying. I found the solution to my problem and now realize I was trying to make this more diffulcult than what it was. Thanks again for looking at it.

 

[James006]

Glad you could fix your problem ...:wink:

Cheers