Search results

Thanks all. Problem solved. After extensive googling, I come across the tool "VBA Code Decompiler and Compactor" https://orlandomvp.org/VBADecompilerMore.asp I don't understand the cause of problem. I just apply the tool to my "Personal.xlsb" and copy back to its original location. Everything...

"Stop" Button on the VBE.

Yes. The core issue is that, after resetting, the whole Excel always crashes. And I need to restart the Excel & VBE to re-inspect the code. I hope to stop the crashing from happening at least.

Hi all, My Excel VBE behaves strangely recently. Whenever I run VBA code in a module and encounter any Error, I will simply press the "RESET" button to re-inspect my code. Recently, after doing so, my Excel will hang for a moment and then prompt an alert window " Automation Error - Exception...

Hi Marc L, Been tested for a whole day. Should be the problem of memory management. After using " ScreenUpdating = False ", problem gone. Thanks again for your GREAT help.

Hi Marc L, Thanks for your insight. After reviewing the VBA code within the Userform, I have turned "Application.ScreenUpdating = True" into "False". Everything seems to return to normal. I will keep monitoring the situation for a week and update you whether this works. * No new add-in...

My "Personal.xlsb" contains a Userform, which comprises lots of command buttons to handle different daily tasks. Long time ago I have created a quick-access icon on top-left corner of Excel toolbar, in order to invoke it more quickly via shortcut "Alt + 1". Such way of calling this Userform has...

Hi All, Is it illegitimate for VBA to use "SET" statement with "iif" ? I got an error for the below coding︰ Dim Rng As Range, URng As Range Set URng = Nothing Set Rng = Range("A1") Set URng = IIf(URng Is Nothing, Rng, Union(URng, Rng)) MsgBox URng.Address(1, 1) Is...

Thank you for your input. Hope the others could solve my problem.

Sorry, I don't understand what you mean. Can you elaborate?

I don't want to tick/untick the items in filter box frequently. Very tedious. What do you mean by double clicking on an agent? Can you demonstrate? It only enters "edit mode" when double clicking on a cell.

https://www.mrexcel.com/board/threads/tog-filter-items-1-by-1-at-a-time.1169249/

No time is required, as long as the user deems it the right moment to display next filter item.

Attached the excel file. Please have a look. For example, for column "Agent", there exists filter items "A", "B", "C", "D". Is there a convenient to loop through and display 1 filter item one at a time, without going through the tedious process of checking / unchecking items on the filter list...

Hi, After applying auto-filter on data, I hope to go through each filter item of a particular column one at a time, so as to take a glimpse on the resulting data. The crude way to do so, is to mouse-check / uncheck the items on the autofilter list. I bet there is a more smart way to do so? (...

have a macro-enabled worksheet with many AcitveX Controls. Suddenly today, all of them become pictures & previously-coded VBA scripts aren't able to work properly upon clicking them. Is there a way to return them back to "ActiveX Control"s instead of "Pictures"? Thanks

Hi, Is there a way to set a shortcut key for "Copy Format" ? Or use VBA to imitate the usual mouse-click / mouse-double-click function of "Copy Format" Thanks a lot!

Ya. Thanks vletm. It helps a bit. But the font still remain not so smooth enough, even I use x3 or x4 zoom. What is more, the output png file is also quite big.

Hi, I am creating an Userform with several command buttons on it. Is there a way to batch rename them as : cbButton1 cbButton2 cbButton3 cbButton4 cbButton5 … ? Note: I hope to give new names to them. not to change their captions. The way I am using now, is simply click on them 1-by-1, and the...

I found the following code in exporting selected range into PNG. It works well. However, the displayed image is a bit non-smooth, especially the font. Is there a way to enhance the export resolution? Thanks. >>> use code - tags <<< Sub CommandButton56_Click() Application.ScreenUpdating...

I am using MS Excel 2013 in a new PC. In my original PC, with MS ExceI 2013, I can hover my mouse cursor on an activeX object and then click on it to run VBA code successfully . However, in this new PC, also with the same version as MS Excel 2013, whenever I hover my mouse pointer on any...

Let 's wait for other response.

how?

Hi, I have the following words written into cells A1,A2, … A9 e.g. appletree applestore appleiphone tweetbird angrybird funnybird bigredhat smallrednose hugeredpocket Upon selecting these cells and applying the VBA script, I would like to highlight common patterns among consecutive cells...

Chihiro, first of all, sorry for occupying your time so much. The file is full of amended formula. So the digit does not appear as it ought to be. Your doubts are right. After re-thinking through your questions, I see many flaws in my current methodology. I guess I will re-design a way to come...