Search : in
By :

Macro button and macro

Last answer on Aug 29, 2009 12:23:25 pm BST san, on Aug 27, 2009 9:11:17 am BST 
 Report this message to moderators

Hello,
Buttonname.caption=iif(buttonname.caption="Update On","Update Off","Update On")

where to paste the above line to create macro button and how to procedd with macro,

Configuration: Windows XP Internet Explorer 6.0

Best answers for « macro button and macro » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
VBA macro to move to the cell 'underneath' ShowVBA macro to move to the cell 'underneath' Issue Solution Issue If you need need VBA macro to move to the cell 'underneath' the particular button that is being pressed, series of buttons down the page, each will run the same macro/do...
Adding a VBA CommandButton with its respective the code ShowAdding a VBA CommandButton with its respective the code Paste these two sub in a general module (Module1 for example). Sub CreateButton() Dim Obj As Object Dim Code As String Sheets("Sheet1").Select 'create button ...
Download Super Macro ShowSuper macro is a free software which allows to create macro under Windows in order to activate diverse automatic actions. Apart being free, this software is easy to use and requires no knowledge in programming. You just simply click buttons, then...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...

1

 Excelguru, on Aug 29, 2009 12:23:25 pm BST

'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 A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

Reply to Excelguru