Macro VBA

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
5,812
Office Version
2019
Platform
Windows
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
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Abusalma02

New Member
Joined
Feb 29, 2020
Messages
13
Office Version
2019, 2016
Platform
Windows, Web
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
Ok. how would i do that?
 

Abusalma02

New Member
Joined
Feb 29, 2020
Messages
13
Office Version
2019, 2016
Platform
Windows, Web
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!
 

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
5,812
Office Version
2019
Platform
Windows
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
 

Abusalma02

New Member
Joined
Feb 29, 2020
Messages
13
Office Version
2019, 2016
Platform
Windows, Web
How can I concatenate an additional string to a data in textbox on a userform
 

Watch MrExcel Video

Forum statistics

Threads
1,099,058
Messages
5,466,328
Members
406,474
Latest member
osama beskales

This Week's Hot Topics

Top