| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a command Button
I would like to insert a command button, that when clicked brings a range of
cells (say B4:B19) to equal 0 . Can some one point me towards a tutorial? Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert a command Button
Hi
try the following: - insert a command button - use the following code statement activesheet.range("B4:B19").value=0 As a starting point for macros see: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Frank Kabel Frankfurt, Germany Dustin wrote: I would like to insert a command button, that when clicked brings a range of cells (say B4:B19) to equal 0 . Can some one point me towards a tutorial? Thank you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert a command Button
Thank you Frank, It works beautifully!
"Frank Kabel" wrote in message ... Hi try the following: - insert a command button - use the following code statement activesheet.range("B4:B19").value=0 As a starting point for macros see: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Frank Kabel Frankfurt, Germany Dustin wrote: I would like to insert a command button, that when clicked brings a range of cells (say B4:B19) to equal 0 . Can some one point me towards a tutorial? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for my Command Button to automatically copy and insert a new | Excel Discussion (Misc queries) | |||
| insert row / insert column command buttons | Excel Worksheet Functions | |||
| Using a command button to insert a new row. | Excel Programming | |||
| Command Button vs Control Button | Excel Programming | |||
| Command Button vs Form Button | Excel Programming | |||
Linear Mode
