414 questions
1
vote
1
answer
67
views
List Named Ranges in Active Sheet
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 ...
- 11
0
votes
2
answers
166
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 ...
1
vote
1
answer
83
views
MsgBox for error handling in a VBA UDF called from cells in Excel?
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 ...
- 58
0
votes
2
answers
120
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
votes
2
answers
66
views
macro should run ahed if msg box is not triggered
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 ...
- 13
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
1
vote
2
answers
103
views
Display MsgBox if cell value changes and is not blank
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
162
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
-1
votes
2
answers
2k
views
Excel MsgBox Ok/Cancel
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:
...
- 109
-3
votes
2
answers
166
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
0
votes
2
answers
76
views
How to get error message text which are sent by Runtime Engine
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.
...
- 389
1
vote
1
answer
58
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 ...
0
votes
1
answer
131
views
Messagebox (OK/Cancel) appears twice on Cancel
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
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
2
answers
75
views
Find empty cells and print their names in MsgBox
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 | ...
- 29
1
vote
1
answer
297
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
0
votes
1
answer
462
views
PowerShell : How to run a script by double clicking on it ? (without 'Run with Powershell')
[EDIT BELOW : The problem was not the MsgBox]
I got a problem : my MsgBox works fine when I run the code from ISE but does not show up when I execute it by double clicking on .ps1 file.
I tried all ...
- 1
1
vote
1
answer
239
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
-1
votes
3
answers
281
views
VBA - MsgBox in Modeless UserForm, how to get the UserForm Object from its Handle retrieved with the API function GetActiveWindow?
All is in the title...
In VBA, is it possible to get the UserForm Object from its Handle retrieved with the API function GetActiveWindow in order to create a MsgBox-like function that works well in a ...
- 11
0
votes
1
answer
102
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 ...
0
votes
1
answer
488
views
Closing a MsgBox after a certain amount of time in VB.NET?
I need to open a MsgBox that closes itself automatically after a certain amount of milliseconds, regardless of user input.
How can I achieve this?
Using most recent version of VB.NET
Attempted to use ...
1
vote
1
answer
342
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
0
votes
1
answer
178
views
Excel VBA Scheduled message pop up box reminder
I want to create a script that sends a msg box at a specific time on a specific day of the week. eg every Monday at 10am.
Sub Reminder()
Dim time As Range
Set time = Sheets("Main&...
- 13
1
vote
1
answer
98
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
0
answers
231
views
How to add an icon to the title of messagebox in VB.NET 2010
I tried to add an icon to the title of the messagebox. I researched at web, but I can't find a good answer. How do I add an icon to the title of the messagebox?
Look to this messagebox:
I tried ...
- 1
0
votes
2
answers
357
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
1
vote
1
answer
873
views
Run Sub if msgbox response is Yes. Exit if No
I have a message box that appears when the workbook is opened. It finishes with a question asking if help is needed.
If the answer is "No" I want to Exit Sub and allow normal usage.
If the ...
- 13
0
votes
1
answer
464
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 ...
1
vote
6
answers
198
views
Using MsgBox and get error msg 1004 when I select "Cancel" - Need the macro to just end normally
First I selected "Yes" to the question "Change Worksheet Name?". Then the message "Type new Worksheet Name" appears. Instead of typing in a new name and selecting "...
- 11
0
votes
1
answer
110
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
0
votes
0
answers
90
views
How to add HTML select/option elemnt into jQuery.msgBox
jQuery.msgBox is a plug-in to make it smarter to display messages. I use jQuery.msgBox in my code. It works fine, but I need to add an HTML select/option element to the displayed message. How can this ...
- 729
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
144
views
Modify Msgbox Form with comma
I write a VBA CODE that's filter a column and return the result in msgbox. The problem is: the msgbox does not show me all the values because the column contains more than 100 values.
My question is: ...
- 13
0
votes
1
answer
716
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
0
answers
43
views
msgbox vb.net textarea equivalent
I want to output a long error (> 200 words) to a user of an vb.net admin app. The user should be able to copy the message and analyze it. the msgbox function doesn't allow me to do that. What ...
- 1,982
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
2
votes
2
answers
14k
views
How to create a Message-Box in Google Apps Script
I am creating an new Google Apps Script about GDrive/New/More/Google Apps Script.
The script is running perfect and on the end my intention is to send a Info on the Desk.
When I am using this line:
...
- 273
1
vote
2
answers
108
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
1
answer
193
views
Change the order of Pivot tables in same worksheet
I have multiple pivot tables on one same worksheet (from left to right : PvtTable 1, Pvttable 2, Pvttable3). I have introduced a iterator (i) to call them one after the other (msgbox their name). ...
- 1
0
votes
0
answers
93
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
0
votes
3
answers
515
views
MsgBox not accepting optional parameters
I'm struggling with this basic piece of code :
If Dir(LocationAddress & "\" & chart & " Complete.pdf") = "" Then
MsgBox("The file ...
- 125
1
vote
1
answer
281
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
32
views
Compare lists and amend msgbox
Im looking to compare all entries in column B of WB1 (can vary in amount up to 300,000), versus a master listing in WB2,tab "Guide", column A (circa 500 entries).
If there are new entries in ...
- 3
0
votes
1
answer
868
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
0
votes
1
answer
233
views
Deleting MsgBox and stop macro from running
Please help to delete msgbox after if statement is met with vbYes. The code also has to stop running so that the user can free type after msgbox disappears.
Here is my code:
Response = MsgBox(“Are you ...
1
vote
2
answers
72
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
2
votes
3
answers
162
views
How to put output, MsgBox Result on new column
I am tracking payments made on a large excel file. In column C, I have the date we received the payment, in column I, I have the date paid. I'd like to calculate how many months between column C (when ...
- 21
0
votes
0
answers
222
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
4
answers
2k
views
How to allow user interaction with spreadsheet when UserForm or MsgBox is displayed in Excel
I have a message box that asks for user input, Yes or No, but need to give the user a chance to cross check another tab if their guess is correct, e.g.
answer = MsgBox("Confirm Deletion?", ...
- 2,629
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