Question about using VBA in Excel to change the value in a looked up cell

An example of your workbook would have been useful.

Maybe, assuming the vlookup is in A1

Please Login or Register  to view this content.

Originally Posted by MrChulo

Hello ExReey,

Not sure I understand your question.

With the formula you have above the result of the formula should update whenever the A38 value is updated, this is expected.

Do you want to update A38 with +1 when pressing the button?

Adding +1 to a cell is simple, just need to understand your question better

Originally Posted by Richard Buttrey

An example of your workbook would have been useful.

Maybe, assuming the vlookup is in A1

Please Login or Register  to view this content.

Thanks for the replies!

I'm creating an interactive combat tracker for a tabletop RPG.
One of the parts is a table with stats for 10 opponents (stats include strength, willpower, and Wounds (=hitpoints)).
When entering combat, players can choose which opponent they want to fight: the selected opponent is in cell A38.
With a random number generator, and after some calculations are done, I get the total damage done to this selected opponent.

So now I want to substract the damage done from the hitpoints of the correct enemy in the table (the enemy currently selected in cell A38).

I want something like Range(*the value in A38 looked up in OpponentTable*).Value = Range().Value - [the damage done].

Here is an image of OpponentTable:

dLCIarN.jpg


Does that make things a bit more clear?

I mentioned uploading your workbook. Pictures are rarely much use. See the standard response below and note the requirement to shoe a before and after.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Thanks for the info.


I added workbook to this post (stripped of all unnecessary components).

1) You choose which opponent you want to fight, using the drop down in cell E23. This picks an opponent from the table A50:Q59.
2) You choose 'ranged' or 'melee' combat in cell C21 (this changes the damage calculations).
3) You press the D100 button, which generates a random number in C24 and F24. Using these numbers, I calculate the damage done to the chosen opponent and write it in cell F26.
---
4) When I press the "Update W" button, this damage number (cell F26) should be substracted from the Wounds number (in red text) of the chosen opponent in the table; the column number of this Wounds cell is 8, but the row number is depending on the chosen opponent in cell E23.
And that's exactly my problem