Combo Boxes / Text Boxes Not Updating

**ckk403** · 01-08-2012, 01:51 PM

I have a List Drop down that allows the user to select Call 1, Call 2, Call 3, Call 4, or Call 5. That links to cell S5. So if a user selects Cell 2, then S5 will populate the text Call 2.

In cell C57 it links to S5 so it also populates Call 2. This value is used in several IF formulas that pull in 5 values (Agent Name, Call Identifier, Date & Time, Duration, and Team Leader) depending on which call is select. This data populates values for C58:C62.

All of the above is working just fine as far as I can tell.

So I have 5 Text boxes that link to cells: C58, C59, C60, C61, and C62. Everything works fine until I make a copy of this tab. The new copy of the tab wont populate new call data, it is stuck on which ever call was selected prior to the copy. The original still works fine, only the copy is broken. If I click on text box, go into the formula bar, press enter, it fixes it. Pressing F9 to recalculate doesn't do anything. I have auto calculation turned on.

I tried switching the Text Boxes to combo boxes and/or list boxes, everything works unless it's a copy. I have tried searching online and it sounds like others have similar problems, but not quite the same. And most of their fixes included VBA, but a VBA that doesn't pertain to my issue. I have found if I save the file, close it, and reopen it... it usually works. However, that isn't the most professional work through with clients.

Help?

EDIT: Well I removed the grouping of text boxes, that didn't work, then I changed them to combo boxes and that didn't work. The version I used as an attachment to this question still had the text boxes grouped. I went into the version of the text boxes out of the group and now I can't replicate the issue. If it happens again I will turn back here for help. I would like to know if anyone has any idea why text boxes are the only ones to update and the combo boxes version wont update? They aren't grouped.

**vlady** · 01-08-2012, 09:39 PM

Hello ckk403

i've notice that the text boxes are grouped..
try to ungrouped them then do the "make a copy of this tab"

HTH

Cheers!

**ckk403** · 01-08-2012, 09:49 PM

Sigh, I've already tried that and it didn't change anything. I greatly appreciate the help. Any other suggestions?

**vlady** · 01-08-2012, 10:15 PM

Copy of CalibrationSpreadsheet-2.xls

:ungrouped text boxes-updating
A copy of your file. it works for me..

did you check the excel option for automatic calculations?

have no idea then if this doesn't solve the issue, i'll try some other way thou..

**ckk403** · 01-09-2012, 08:22 AM

When you say that you made a copy of the file? Are you saying the whole file or just the tabs? If I save and close out of the file it works. It's when I make a copy of either tab 1 or tab 2 that the new copy doesn't work unless I save and close out again.