sumadiwaters
New member
- Joined
- May 20, 2016
- Messages
- 5
- Reaction score
- 0
- Points
- 0
Hello Excel VBA People!
This is my first post, and it's first time I’m looking for help officialy on this forum. I've been reading many good posts here before, and thank's to all of you.
I have Workbook and inside realy specific column A, every cell contains a lot of string data (news, TV transcript etc...). Workbook can contain 1000 – 2000 rows, maybe 10.000, no matter, no limit....
I wrote VBA code for marking specific keywords Array (1000)) which means 'Green color', 'Bold' and 'Underline', and everything working fine, but after that command (Run VBA code), program (Excel), not working properly, actually, working, but slowly. What I need is next option, for other operators in my team: simply F2 (edit cell - column A) and quickly view of marking words.
What can be problem, some format options, or something else (full clipboard)?
How to make Excel to work same as it does before running VBA and marking keywords?
Random exampe is in attach...
This is my first post, and it's first time I’m looking for help officialy on this forum. I've been reading many good posts here before, and thank's to all of you.
I have Workbook and inside realy specific column A, every cell contains a lot of string data (news, TV transcript etc...). Workbook can contain 1000 – 2000 rows, maybe 10.000, no matter, no limit....
I wrote VBA code for marking specific keywords Array (1000)) which means 'Green color', 'Bold' and 'Underline', and everything working fine, but after that command (Run VBA code), program (Excel), not working properly, actually, working, but slowly. What I need is next option, for other operators in my team: simply F2 (edit cell - column A) and quickly view of marking words.
What can be problem, some format options, or something else (full clipboard)?
How to make Excel to work same as it does before running VBA and marking keywords?
Random exampe is in attach...