Macro VBA

Abusalma02

New Member
Joined
Feb 29, 2020
Messages
17
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
  2. Web
Hello! Please what can i do to make my macro VBA working fast i have about 6 to 7 pages of marco (Userform up to 7) on my workbook and it took a long time before it open. But for the first, send and third page of my sheet, the userform on them were working as expected, but for the fourth page their is about three userforms which the first one for it to post data on to worksheet it is so annoying. so Please if there is anything to do to aid the workbook very fast. Thank you
 
Thank you sir, but am still experiencing the same problem.
Don't you think it might be the heaviness of the workbook or something else?
May be I need a code to run it faster!

without seeing your workbook we can only but guess at what your issue might be.
If you are able, place copy in a dropbox & provide link to it.

Dave
 
Upvote 0

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Hello! please I want to concatenate a textbox on userform by adding a string to the data (i.e. to show "Balance:" plus whatever is the data on this textbox) please help out!
 
Upvote 0
Hi,
I am addressing the issue you posted about your workbooks speed - Having had a look at it I notice on your customers tab, you have dragged formulas down for every row in Columns K & L - I suggest that you DELETE all the unused formulas & only add them as needed & see if this helps with you workbooks speed issue.

If not, your workbook may have a corruption & may need to try & repair it which you can do as follows

- Make a BACK-UP before trying this

Repair a corrupted workbook

1 -Click File > Open.

2- Click the location and folder that contains the corrupted workbook.

3 -In the Open dialog box, select the corrupted workbook.

4 - Click the arrow next to the Open button, and then click Open and Repair.

To recover as much of the workbook data as possible, pick Repair.

This is just an idea & others here may be able to offer further guidance but suggest that you resolve this issue first before trying to develop your project further.

Dave
 
Upvote 0
How can I concatenate an additional string to a data in textbox on a userform
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top