MACRO VALUE

[TN]

Good Day!

I am creating a fairly straight-forward accounting
spreadsheet. I have created a macro that automatically
generates a note in a cell (red tag). Very simple.
However, I want to create some sort of function or macro
that every time I run this macro (through a command
button I have created) I would like a value to add to the
value that exist in the cell.

Example.

$1000 is a value in a cell. When I hit the command
button, which runs the macro, a note appears. I would
also like $100 to be added to the cell value, equaling
$1100. Is this possible?

This is a great forum! Thank you in advance!

TN

 

[Paul B]

TN, use something like this

Sheet1.Range("A1").Value = Sheet1.Range("A1").Value + 100

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[TN]

within the macro

-----Original Message-----
TN, use something like this

Sheet1.Range("A1").Value = Sheet1.Range("A1").Value + 100

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **




.

 

[Paul B]

within the macro
TN, yes if you want the valve increased every time you run your macro that
generates the note in the cell,
just put it at the end of your macro
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **