Thread: Update Botton
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Update Botton

The macro part would be an Event Macro, see
http://www.mvps.org/dmcritchie/excel/event.htm
but then you wouldn't need a button.

But if you want a button to invoke a macro, you can create
a button on the toolbar (or in a menu) see
http://www.mvps.org/dmcritchie/excel/toolbars.htm
or you can create a shape, right click on it and assign a macro.
--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"saman110 via OfficeKB.com" <u35670@uwe wrote in message news:75f7ff5f169e8@uwe...
Hello All,

Can user create bottons in excel to do something? If yes How can I create a
botton to update a cell.

Or a VB to update a cell every time I click somewhere.