Randbetween function embedded in a macro HELP

CuriousG · #1 02-20-2021, 07:12 AM

Hello everyone, I wonder if there is anyone who can help me please.

From a list of 10 names manually inserted in a spreadsheet I want to invoke a macro by pressing a button (I know how to do this bit). The macro will then randomly a number using the RANDBETWEEN function and highlight the corresponding name in the spreadsheet (this is the bit I don't know how to do).

Ideally I'd like the random selection to be relatively evenly spread across the 10 names but don't know if this is possible to control using a random function.

Purfleet · #2 02-21-2021, 01:51 AM

Try something like this

Code:

Sub Randomly_generate_a_number_between_1_and_10_inclusive()
'
' Macro1 Macro

    Range("b:b").Interior.Color = xlNone
    
    randnum = WorksheetFunction.RandBetween(1, 10)
'
    Range("D2") = randnum
    
    Range("A:A").Find(what:=randnum, LookIn:=xlValues, lookat:=xlWhole).Offset(0, 1).Interior.Color = vbYellow
       
    
End Sub

p45cal · #3 02-21-2021, 05:32 AM

Mixed messages in your file (button text) and the narrative in msg#1!
In the attached 3 buttons doing various things, each calling a one-line macro, along with some conditional formatting on the sheet. More explanations in the attached.

CuriousG · #4 02-21-2021, 10:48 AM

OK guys thanks very much for your help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RANDBETWEEN question	derohanes	Excel	3	01-25-2019 09:38 AM
Calculating bonus in an embedded IF function	Yde1203	Excel Programming	2	07-22-2018 08:24 AM
RandBetween for PowerPoint	excelledsoftware	PowerPoint	1	09-19-2014 11:32 PM
RandBetween Formula Help	acbh	Excel	1	09-12-2013 06:51 PM
word macro that reformats embedded links in a doc	EricT	Word VBA	7	09-12-2012 04:13 PM