Active X Text Box not updating

[jonhfl]

Hi,

I have the following code to process a validation list and print to pdf for each item. I have multiple Active X text boxes on my worksheet that are Linked to a cell. When I run the macro the text boxes are not updating. Does anyone have any idea how to fix this. I think it has something to do with the active X not being able to update while code is running.

Please Login or Register  to view this content.

The list is 36 items so the goal is to be able to process all 36 PDFs by running just one macro. The macro works great and everything updates except the Active X text boxes.

Thank you.

[6StringJazzer]

The issue might be somewhere other than your code. Can you attach the workbook?

Also, in VBA you do not have to select objects to do things with them. Selecting things takes longer execution time, and also looks goofy to the user. For example, your code could be (unable to test without having your workbook):

Please Login or Register  to view this content.

[jonhfl]

Thanks for the edits. I was trying to figure out a way to do the offset without having to select but couldn't work it out. Set will be very useful in the future.

Unfortunately I can not attach my workbook due to information security. I have basically built a few graphs and the values of those graphs are displayed in Active X text boxes. In those boxes I have the linked cell section on the properties linked to the same cell driving the chart. When I select a new value to drive the chart data the chart changes and so do the text boxes however when it is being done through the macro it is changing the chart but not the text boxes. Even when I do it manually the text boxes refresh a few seconds after everything else.

[6StringJazzer]

I'm afraid I haven't seen this kind of issue before so can't diagnose it without seeing the workbook. Someone else may be able to.

Set will be very useful in the future.

The Set keyword means assign one object to point to the same place as another object. A plain vanilla assignment copies a value from one to another:

Please Login or Register  to view this content.