413 questions
0
votes
2
answers
154
views
Close a MsgBox without employing timers and without user intervention, while allowing other VBA code to run
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 ...
0
votes
2
answers
113
views
Excel VBA: Use MsgBox if Replace finds nothing to replace
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
vote
1
answer
61
views
VBA Message Box To Choose What XLA File To Attach
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 ...
- 73
0
votes
2
answers
159
views
Accented characters in MsgBox and Project Object in Office 2021 not showing
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?
...
- 11
-3
votes
2
answers
161
views
How to extract enums strings from values in VBA? [duplicate]
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("...
- 389
1
vote
1
answer
56
views
problem invoking msgbox after closing one document in python. object has no attribute 'getCurrentController'
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 ...
1
vote
2
answers
97
views
Blocking cell editing after using msgbox
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
...
- 43
1
vote
1
answer
292
views
Excel VBA, MsgBox Yes or No, but must be "Si" or "No"
I have a fairly easy question that I think there should be an easier way to do it, but I haven't been able to find the answer that I want.
Pretty simple,
I have a MsgBox with +vbYesNo,
But my end user ...
- 43
1
vote
1
answer
234
views
Use MsgBox in Inno Setup to ask questions before Installation
How to make installer to ask a question before opening the installer?
For Example:
It will ask "Are You Over 18?" then user can select whether "Yes" or "No".
If user ...
- 25
0
votes
1
answer
95
views
I am a beginner with vbscript and this msgbox popup many times as it reads the string mutilple times. Can we do something so it only throw one msg
If InStr(currentoption,"INTUM")>0 Or InStr(currentoption,"SHIM")>0 Then
MsgBox "INSTALLER SHIM ET/OU INTUMESCENT ( VOIR W.O. ET CARTABLE INSTRUCTION INSTALLATION DE ...
1
vote
1
answer
341
views
VBA - Msgbox inside a Loop
I have the attached userform. Whenever I click on the "Proceed!" button, I have it check if the sum of batches weight is more than the first assigned weight in the Product Details frame;
if ...
- 21
1
vote
1
answer
91
views
Prevent a MsgBox from a different VBA script from popping up
I have written a script in the workbook that sends a msgbox warning users not to copy and paste cells whenever they do so.
Target.PasteSpecial xlPasteValues
If Application.CutCopyMode = xlCopy ...
- 13
0
votes
2
answers
352
views
How to call the MsgBox Function
How do I “Call” Vba’s MsgBox function? Is this the same as just using the actual function itself? I want to make a MsgBox function that returns the date and time.
- 11
0
votes
1
answer
453
views
I need to position a popup box [duplicate]
I need to position the popup boxes towards the top right corner but just below the close minimize and maximize buttons.
Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")
Do
set ...
0
votes
1
answer
108
views
Can I print range in a MsgBox as well as text?
I'm writing a macro on excel.
Every time a value is typed in a specific range, if the calculated result is too low, I need a message box to appear saying ""Sample volume too low! Please ...
- 1
1
vote
1
answer
333
views
Warning before overwriting existing data in VBA
I have the below code that creates a pop-up when new data is pasted into the specified range (A15 : E33). What I would like is when the user attempts to paste data into the range the pop up shows up ...
- 67
0
votes
1
answer
715
views
How do I insert developer buttons into a message box?
I am trying to insert Optionbuttons into a msgbox in VBA. However, I cannot find the Optionbutton in the object browser. Below is my current Incomplete code:
MsgBox(ActivePresentation.Slides("...
0
votes
2
answers
1k
views
How do I check if a button is pressed in a VBScript 'MsgBox'? [duplicate]
How do I check if I click on a button in a MsgBox?
x = msgbox("Test", 0+16, "Test")
I meant check, not how to make a message box!
- 33
1
vote
2
answers
107
views
How to use a formula to generate a date as a default value in an input msgbox?
I am trying to make my input message box a bit more sophisticated by using a formula to generate a default date in an input message box in excel.
Currently, it just gives a default value of "dd-...
0
votes
0
answers
91
views
One time msgBox on Google Sheet
I need to put an alert on my teams planner on Google Sheets to remind people to do something.
Someone told me is unusable to see this popup any time the file opened.
How can I fix my code for showing ...
- 1
1
vote
1
answer
279
views
Go to a referenced cell when clicking "ok" in the message box
So my code starts on a different sheet with a button click. The code below stops the user from continuing with an error message if the user does not put in a value in cell "B38" on the "...
- 27
0
votes
1
answer
867
views
VBA MsgBox - How to display multiple messages
Would someone be able to advise on the below
Is it possible for a MsgBox text to display multiple messages dependent on the criteria met.
I am looking to get the Msgbox "Not enough Monitors in ...
- 19
1
vote
2
answers
66
views
How to have Msgbox appear or not appear selectively
Sub Process_A()
\<some code here\>
MsgBox "Process completed."
End Sub
Sub Process_B()
\<some code here\>
MsgBox "Process completed."
End Sub
Sub Process_C()
\<...
- 11
0
votes
0
answers
221
views
ThisWorkbook.Activate is not working correctly at all computers
In Book1.xlsb in ThisWorkbook module I have a simple code:
Public Sub Workbook_Open()
ThisWorkbook.Activate
MsgBox ThisWorkbook.Name
End Sub
which activate Book1 workbook after opening.
If another ...
- 13
0
votes
0
answers
156
views
Macro VBA message box for triangle side
I am trying to create a macro that asks the user the side of a triangle and that displays its properties. We may control the validity of the parameters, displaying the error messages when needed.
I ...
- 9