Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell math to decrement/increment a cell BUFFETT Excel Worksheet Functions 1 June 16th 06 08:37 PM
Options should provide browse buttons under settings. MartinJ Setting up and Configuration of Excel 3 June 8th 06 07:26 AM
How do I increment or decrement values in a column? OldKenGoat New Users to Excel 3 January 6th 05 01:05 AM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Excel Programming 2 March 3rd 04 03:31 PM
Spin Button to increment or decrement the date in cell A1 Pal Excel Programming 5 August 4th 03 11:43 AM


All times are GMT +1. The time now is 08:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"