Macro button and macro
Closed
san
-
Aug 27, 2009 at 04:11 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 29, 2009 at 07:23 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 29, 2009 at 07:23 AM
Related:
- Excel vba assign macro to button programmatically
- Number to words in excel formula without vba - Guide
- At button - Guide
- Vba case like - Guide
- How to open vba in excel mac - Guide
- How to answer call with volume button android - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Aug 29, 2009 at 07:23 AM
Aug 29, 2009 at 07:23 AM
'First create the button and then
'put the above code a module in a procedure as shown below
Sub buttonName_Click
Buttonname.caption=iif(buttonname.caption="Update On","Update Off","Update On")
End sub
'put the above code a module in a procedure as shown below
Sub buttonName_Click
Buttonname.caption=iif(buttonname.caption="Update On","Update Off","Update On")
End sub