application.calculation

Hi. I am trying to make a survey in excel 2013, using ActiveX option boxes and Sliders, having the user's selection populate the data on a second spreadsheet. I have the data populating properly but unfortunately for some reason the sliders are glitching. They multiple and hover on the screen as...

Hello everybody. When I open the workbook, I need to inactive all formulas except in a specific sheet. I've composed the following code, but unsuccessfully. Private Sub Workbook_Open() Application.Calculation = xlManual Application.CalculateBeforeSave = False Worksheets("Second...

Good Morning all.... Got an odd one in that what I have is working, just not well.... I have a sheet with two columns and 100k plus records Col A contains a text description that is fetched by a VBA Cut and Paste from another sheet. In ColB I have automated a COUNTIF to copy from Row2 down...

First of all I would like to thank you for taking your time to read my post, and preferably providing me with a solution to my problem, any input or assistance will be greatly appreciated. :help: I have read several posts about the importance of minimizing traffic between VBA and excel, the...

I have a fairly complex workbook which contains a worksheet I use as a template for a new workbook - I populate this as part of a long script which fires when I click a command button on a form, then copy this sheet to a new workbook which I create and save in the same script. This works fine...

In many of my subs I turn off one or more of Screenupdating, Calculation (mode) and EnableEvents. To simplify this I have a single sub . Public Sub SetAppItems(Optional tSState As Variant, _ Optional tCState As Variant, _...