| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label with randomly selected text from cells
Hello everybody,
I was given the following code yesterday by Tom Ogilvy to select a text randomly from a list of cells in a message box. Sub Text() Set rng = Sheets("sheet2").Range("A1:A5") i = Int(Rnd() * rng.Count + 1) MsgBox rng(i) End Sub The question is how can I do the same for the text of a label in a userform? Thank you for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what can I do to randomly select cells that contain text? | Excel Worksheet Functions | |||
| Randomly populating empty cells with other text cells | Excel Discussion (Misc queries) | |||
| Selecting the value from a randomly selected cell out of a range | Excel Discussion (Misc queries) | |||
| how to sort a column of Randomly selected numbers? | Excel Worksheet Functions | |||
| How to generate a list of randomly selected numbers within a range | Excel Worksheet Functions | |||
Threaded Mode
