updating

I have set Application.ScreenUpdating = False And, it turns off screen updating except for one thing. When i activate a different workbook (with Windows(bo).Activate) the screen changes to that different workbook. Since this is within a loop, it is happening many times. And, this...

No biggie here. While some of my macros are running, I have ScreenUpdating=false . I update the progress for the user by changing the Caption on a Command Button and then turn on Updating and then turn it off. It works just fine. I was wondering, however, if there was a way around turning...

I have a set of data that tracks tread depth measurements at multiple points for each truck (64 total measurements per truck, per day); I need to create a set of charts which separates out each truck and tracks their regression over time with the horizontal axis being date and vertical...

Hi all, I need both the list and the value of a combobox to update from the macro initiated from another combobox. So imagine I have a Combobox called "Region". And another combobox called "Countries". Both are defaulted to "All" as the selection until an action is taken. If a user selects...

Hello, I’m not sure if what I want to do is possible but I have a user form (screenshot attached) what I would like to know is if there is a way to automatically update the ‘Agent’ field with the name of the person updating the form?

Greetings, I'm not an access guru. I mostly do queries. A workmate has inherited a work database which mostly contains forms, queries, and tables. One of the tables has ~14000 line records. They have been finding there some records in a table (table linked to form) and their fields have been...

Hi, Aside from going to the ribbon Formulas > Calculations Options and ticking manual is there any other way to disable a cubevalue formula updating unless commanded to update?

Hello, I have a very large spreadsheet with many tabs with links to different workbooks. The only thing I have to change is the 2017 to 2018 in the links. What would be faster, edit/replace or updating links?

Hi, everyone! I'm currently doing a VBA application for updating a company's stock. I'm trying to get the data from the UserForm combo boxes and text boxes to go into a spreadsheet but all I have so far is data going to the chosen cells. Everytime I clear the UserForm and add other data, those...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I have 2 files where cells from one sheet in file 1 is linked to cells in file 2 worksheet. File 1 is the source and file 2 is the destination file. I have used the copy and...

Hi, This is a long shot. I've set up a connection to a website that pulls historical data into a table in my spreadsheet. I've used the URL below to create the connection/query. My question is is there anyway of automatically updating "end=20180115" so each day when I refresh the spreadsheet...

Hey, Merry Christmas. I have large excel file with formulas that goes very slow on updating. Kindly what to do making it goes faster???? Cheers, Mawama

Hi, I have a daily task of updating the names in a spreadsheet multiple time with a specified number. Example:- As in the given below column A will have names and column B will have numbers. In Column C the name should appear multiple times repeated based on the number updated in column B...

I have a workbook that I am trying to reference another workbook on the network with a dynamic snapshot. I notice that it will not update unless I open the source document. How would I force the snapshot to update upon opening? I am using snapshot because the sheet has pictures on it that I want...

Hi, I have a update query in which I only want to update all records within my main table that is equal to the criteria set in the second table of USD. My problem is that since the CURRENCY field doesn't exist in the main table, the update query loops over and over again. My main table has...

Hi I have 2 form controls where i have attached some code to update some charts on my sheet.. For some reason even after turnimg the screen updating off, it hides all my ovjects and charts before updating all the charts so its like you can see that the charts and most objects get hidden whilst...

So I have a sheet with multiple pie chart graphs on it with a vba code that pulls out of an SQL database. What I am running into and I feel like an actual bug in Microsoft excel. My VBA code changes the color of the pie charts based on a few different variables and the code is set to cycle every...

I would like to refer to a value in column A for each row. For example, when the value in A2 = the value in column J and the values are greater than V2 (8/29/17) and less than X2 (9/13/17), then sum column P. The formula works, but it's a lot of copying and updating formulas as I need to...

I want to provide for automatic updating of values between two independent workbooks. Workbook A contains several price quotes. I’ve copied those quotes, using Paste Special/Paste Link into Workbook B. However, when I change the values in Workbook A, the new values are not automatically...

I have as spreadsheet that shows its data in a userform listbox, when the data is selected from the listbox and the edit button is clicked it opens up a second userform CustEditForm and populates the texboxes. This bit is fine This is the code that does this Private Sub CommandButton2_Click()...