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 |
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 |
All times are GMT +1. The time now is 09:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com