Application screenupdating false not working excel 2016
Cells(j, 35) = "" Then Go To 100 myconcat = myconcat & ws. Cells(1, 35) = myconcat myconcat = "" For j = 6 To 1000 If ws.
Most people like me and you are not real Microsoft Office gurus.
Using the sheet code will ensure that the code will always work. Sheet17 is the sheet that Macro41 works in, the code is below...
Select For j = 6 To 1000 If Cells(j, 35) = "" Then Go To 100 myconcat = myconcat & Cells(j, 35) Next j 100 Cells(1, 35) = myconcat myconcat = "" For j = 6 To 1000 If Cells(j, 38) = "" Then Go To 1000 myconcat = myconcat & Cells(j, 38) Next j 1000 Cells(1, 38) = myconcat End [email protected] Louis H, The OP is referring to the sheet code not the sheet name. Row Dim Copy Destination As Range Set Copy Destination = ws.
When the selection in Combo Box7 changes, Macro41 changes cells values in Sheet17, a Text Box (Active X Control) located below Combo Box7 in Sheet8 reads from the new cell value in Sheet17. After further experimentations, I discovered that you don't even need the sheet to be visible to operate on it. Screen Updating = True err Handle: End Sub Sub Macro41() Dim ws As Worksheet Set ws = Sheet17 Dim lrow As Long lrow = ws.
Screen Updating incorporated but the screen still flashes/flickers when the code runs - everything (charts/tables etc.) momentarily disappear and re-appear when it runs so it doesn't look very slick. Private Sub Combo Box7_Change() On Error Go To err Handle: Application. When the selection in Combo Box7 changes, Macro41 changes cells values in Sheet17, a Text Box (Active X Control) located below Combo Box7 in Sheet8 reads from the new cell value in Sheet17.
The page has a couple of charts reading from other sheets, some tables with formulas, text boxes reading from other sheets and some combo boxes being used as dropdowns.
This means that the Excel screen can look like it has "gone crazy" while the macro is running.
One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.
After the code is executed, everything is turned back on.