Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
1 vote
1 answer
70 views

I want a MsgBox that displays the names of the "Named Ranges" in the active worksheet, along with the "RefersTo" field. I created a macro that I thought would work, but when I ...
0 votes
2 answers
169 views

I have a VBA program which performs a sequence of tasks and takes many 10s of minutes to run. I'd like to keep the user apprised of the program's progress. Each task has VBA code running the Excel ...
1 vote
1 answer
85 views

Is it possible to allow Excel users to stop MsgBox messages from VBA error handlers popping up and also re-allowing MsgBox messages? Or is it possible to programmatically control their frequency, for ...
0 votes
2 answers
122 views

I'm using a simple code to find values in a range and if that value is found, all instances of it are cleared with a "". The code: Sub Clear() Range("A1:R34").Replace What:=...
-1 votes
2 answers
66 views

I want my macro to continue if the yes no msg box is not triggered. currently i have set a yes no msg box in my macro. for example if the value in cell A1 is more than 100 then the msg box pops up and ...
Samy Somy's user avatar
1 vote
1 answer
62 views

So we have a legacy spreadsheet that isn't going anywhere anytime soon. I've maintained two of them because there are times when we need different code to import a job. Upon opening the sheet, it ...
Brian's user avatar
  • 73
1 vote
2 answers
103 views

I have a range (merged cell) M5:O5 that needs to trigger a MsgBox as follows: If range is edited and is not null If range is deleted to a null value then no MsgBox If range is selected and box is ...
0 votes
2 answers
164 views

All language settings (Windows 10, Office 2021) are set to French. MsgBox does not display the accents. In the VB Editor: At run time: In the Project Object list: Where is the setting if existing? ...
-1 votes
2 answers
2k views

I have a procedure that should only start if a condition is met. In this example the condition is ActiveWindow.Zoom = 200 Trying to use a MsgBox with vbOkCancel to say: check the window zoom level: ...
-3 votes
2 answers
171 views

I want MsgBox shows me msoPictureAutomatic instead of 1. Because I want to get a enum name not a enum value. Please note that 1 means msoPictureAutomatic Sub Macro1() Sheets(1).Pictures.Insert("...
0 votes
2 answers
78 views

Run the following macro. Sub Macro1() MsgBox "Hello" End Sub When the MsgBox pops up, press Ctrl+C keys on your keyboard. Open a NotePad file and press Ctrl+V keys on your keyboard. ...
1 vote
1 answer
84 views

1 I open one stored document, store it, call MsgBox, close de document. 2 I open a new document and call MsgBox again and get object has no attribute getCurrentController I thought that after closing ...
0 votes
1 answer
131 views

The following code checks if a file starts with te right name, after that in checks what the user wants. Most of the code works fine but if the users presses "Cancel", the messagebox re-...
1 vote
2 answers
99 views

I have a workbook with various improvements (macro, formulas). By default, the workbook opens in full screen mode. Private Sub Workbook Open () Application.DisplayFullScreen = True End Sub ...
Grzegorz's user avatar
1 vote
2 answers
75 views

I am working on an archive system where a user lists information about a machine using data validation. This information gets transferred to a table that looks like this: | Unit | Machine | PC | ...
heiavieh's user avatar

15 30 50 per page
1
2 3 4 5
...
28

AltStyle によって変換されたページ (->オリジナル) /