Add a dialogue box

[nkitchen31]

If a cell has a value in it, I would like have a box come up and ask for a value (number). There are a possibility of 15 cells. And I want a different cell to add up all the times that I put in the dialog box.

Thanks in advance!

[nkitchen31]

Like if any of the cells between F5:F20 have an "x" then it'll ask how much time. And it'll keep track of all the times entered and add them up in A5.

[mikerickson]

First put =SUM(F5:F20) in A5


Then this Sub could be run to get your values.

Please Login or Register  to view this content.

[nkitchen31]

I did that in the Visual Basic editor... and nothing happens when I put an "x" in those columns...

[nkitchen31]

Here is a screenshot. Thanks for your help.

Screen Shot 2017-01-16 at 4.22.00 AM.png

[nkitchen31]

Perhaps there is a different way to do this? B4 needs to be added up automatically, all the times that are entered in the "Enter Credit" if there is an "x" in the I column.

[Logit]

Did you add a CommandButton attached to the macro "Sub Test() so when clicked it will fire the macro ?

[nkitchen31]

Negative ... I haven't done VB since high school bak in the late 90's ... I don't remember much haha. But is there a different way to do this besides VB and having to add in extra steps? Thank you.

[Logit]

You could place the macro in the Sheet Change event.

Both of these look the same but they are not. Closely look at the Sub name at the top of each. This goes in the VBE editor window for the affected worksheet.
In your pic you have Sheet3(Feb) highlighted. If you click on that, as you did to insert the first version of the macro, delete the existing macro, then paste
one of these in its place.

You only need to paste one of the macros. I would start with the second one.


# 1

Please Login or Register  to view this content.

# 2

Please Login or Register  to view this content.

[Logit]

I've tried the two new macros. Neither one works satisfactorily.

Try this :

Please Login or Register  to view this content.

[nkitchen31]

I will check it when I get to my computer. Thank you.

But the value of the cells should still be "x", but the sum of B5 should be all the values that were entered into the "Enter Credit" msgBox ... make sense?

Thanks again!

[Logit]

.
Add this formula to the Formula Bar for cell B5:

Please Login or Register  to view this content.

Change the macro code to this:

Please Login or Register  to view this content.