ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Provide increment and decrement buttons on toolbar line (https://www.excelbanter.com/excel-programming/312271-provide-increment-decrement-buttons-toolbar-line.html)

excelstudent

Provide increment and decrement buttons on toolbar line
 
I have an application that could use a feature that would increment or
decrement the contents of a specific cell, by clicking on buttons somewhere.
The ideal place would be cells right next to the number cell, but if there
were the ability to add a couple of buttons to the toolbar that could be set
to refer to any specific cell, that would work.

Since I don't have VBA, I am looking for an existing function, in the
current Excel 2003 or the next version, that would have these functions in
the function library supplied with the spreadsheet itself.

The specific application invloves using a cell as an index into the rows on
a different Sheet, so that the current sheet can extract and display
information from that row, with the ease of single-click stepping through the
rows.


Norman Jones

Provide increment and decrement buttons on toolbar line
 
Hi ExcelStudent,

I have an application that could use a feature that would increment or
decrement the contents of a specific cell, by clicking on buttons
somewhere


Perfectly possible with VBA

Since I don't have VBA, I am looking for an existing function, in the
current Excel 2003


Use your Excel/Office distribution disks to load VBA.

Once you have accomplished this post back.

---
Regards,
Norman



"ExcelStudent" wrote in message
...
I have an application that could use a feature that would increment or
decrement the contents of a specific cell, by clicking on buttons
somewhere.
The ideal place would be cells right next to the number cell, but if there
were the ability to add a couple of buttons to the toolbar that could be
set
to refer to any specific cell, that would work.

Since I don't have VBA, I am looking for an existing function, in the
current Excel 2003 or the next version, that would have these functions in
the function library supplied with the spreadsheet itself.

The specific application invloves using a cell as an index into the rows
on
a different Sheet, so that the current sheet can extract and display
information from that row, with the ease of single-click stepping through
the
rows.





All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com