Screen Refresh

[cswain99]

I have a macro that connects to the database and puts some info into a textbox. It then Makes a chart with a picture of the textbox and saves it as a file on the hardrive. When I open the picture there is no Values in the Textbox The Issue is that the Values do not go into the textbox until after the macro is done running. Is there a way to refresh the Values of the textbox before it Exports the picture?

 

[cswain99]

Bump

 

[RSXchin]

Make sure you turn on screen updating at that point in the code

Application.ScreenUpdating = True
'''''and then after you take the picture
Application.ScreenUpdating = False

 

[cswain99]

Tried that but the textbox still does not show the value in the textbox until the macro is finished running

 

[SuperFerret]

Maybe if we could see your code it might be easier?

Paste it to the forum using code tags
(type [ C O D E ] put your code in here then [ / C O D E ] without the spaces in the square brackets) as it sounds like your code needs rearranging