Macro VBA

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
5,922
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

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Abusalma02

New Member
Joined
Feb 29, 2020
Messages
14
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
14
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,922
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
14
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,102,545
Messages
5,487,496
Members
407,603
Latest member
jortronm

This Week's Hot Topics

Top