Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what to use
I am working in excel and i if i wanted to send this file to someone and i
would like for them to click a button of some sort once they click on the button it will display a message to them how do i do this?-- Thank you, Brenda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what to use
Insert a button on the worksheet from the control tool box by clicking on
button and drawing it on the worksheet Right-Click on the button and choose view code add the line MsgBox "Replace this with your message" between Private Sub CommandButton1_Click() End Sub Exit Design Mode Sub MacroForButton() MsgBox "Replace this with your message" End Sub "Brenda" wrote: I am working in excel and i if i wanted to send this file to someone and i would like for them to click a button of some sort once they click on the button it will display a message to them how do i do this?-- Thank you, Brenda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|