Replies

Edited by DaveA to make links.
Thanks Gladys,

I searched and found and Q187611and both articles confirm that both instances are necessary.

Thanks again.

Thanks Legare,

Your post made me look at it differently and I was able to convince the user to redesign the spreadsheet.

Thanks again,

Thanks! I’m still learning (as you can tell) and your feedback helped alot.

Thanks. It works like a charm!!

Yes, it works. Thanks!
Can you explain what is meant by the “long” in Dim lRow As Long?

I’m a little confused as to what SH is and how I tell it that Sname is the tab names. When I paste your code at the end of my code I get an error message “For Each control variable must be a Variant or Object”

Your macro will run after you click on the button in the upper left-hand corner of the control toolbox to “Exit Design Mode”.

It was just a portion of the code and yes, I do have it at the end.

Thanks for the heads-up though.

I fixed it to handle a null MyValue and it works great!

Thanks a lot.

Are you saying that if I use a Type of 2 they will only be able to enter a tab name that is data (alpha, not numeric)?

[i.e. MyValue = Application.InputBox(Prompt:=Message, Title:=Title, Type:=2)]

I did fix the Escape issue by checking for a null MyValue and handling.

I also added the application object in front of ScreenUpdating = False and it works much better.

Thanks.

I see now. Thanks for your help.

Thanks. And range names do help!

Fred,

The formula works like a charm!!

Thanks.

Thanks for the help but I think I wasn’t too clear on what I was trying to do. I’m not concerned with calculating time but rather incrementing the sum of 2 cells by 4% each year while also adding a base amount. The formulas I am using for year 1, 2, and 3 are below. I’m thinking there is a function I could use that would treat the amount that is growing (cells D10-11) like an annuity that earns interest (4%) AND would also let me add on the base amount (cell D9)

=SUM($D$10:$D$11)*1.04+SUM($D$9)
=SUM($D$10:$D$11)*1.04*1.04+SUM($D$9)
=SUM($D$10:$D$11)*1.04*1.04*1.04+SUM($D$9)

While my formula works, it seems rather unsophisticated.

You’re right, I wasn’t clear where the cells were, and they can be most anywhere depending on the project.

Thanks for your help and advise. The macros make a tedious job a lot easier!