Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with VBA
I would like to use a command button for this excel formula
=randbetween(1,100) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with VBA
Hi,
I would like to use a command button for this excel formula =randbetween(1,100) Try: '============= Private Sub CommandButton1_Click() Selection.Formula = "=RandBetween(1,100)" End Sub '<<============= --- Regards, Norman |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with VBA
I'm sorry what I meant was Cells(3,3) = randbetween(1,100)
"Norman Jones" wrote: Hi, I would like to use a command button for this excel formula =randbetween(1,100) Try: '============= Private Sub CommandButton1_Click() Selection.Formula = "=RandBetween(1,100)" End Sub '<<============= --- Regards, Norman |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with VBA
Hi Need help with sumif,
I'm sorry what I meant was Cells(3,3) = randbetween(1,100) Try: '============= Private Sub CommandButton1_Click() Me.Cells(3,3).Formula = "=RandBetween(1,100)" End Sub '<<============= --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|