message

Hi all, On UserForm I have textBox were user should enter school name, I would like, if the name already exists, to get message that the name exists & Focus stays in same TextBox (not move to the next control) Thank you in advance.

Hello Everyone , I am trying to create an excel application for leave, I have got the template online and its perfect for me. I want to create a validation while applying leave and need your help for this. While applying for leave the system checks the employee column (Employee are divided...

Seeking assistance with the final step of a report I've generated! I've created a macro that will copy a set range in excel and paste into the body of an email as an image. I'm experiencing issues with the picture resolution when reading on a smart phone device. To improve the resolution I've...

We have a spreadsheet which has ranges that are password protected (i.e. using AllowEditRanges with a password). This is not because we don't want users to be allowed to ever change those cells, but rather it is to prevent them from changing them accidentally. Users are provided with the...

Hello, I'm created an outlook template with a macro-enabled workbook attached. When the recipient saves the workbook, the calendar form doesn't pop up in specified cells even after the person had clicked 'enable content' when the warning message about macros popped up. Is this a problem that...

I am working on a code to fire a message box is a certain CheckBox133 is selected and if cell B225 is greater than $75,000. The code below works and message fires, the problem is that it fires any time a cell is changed. How do I limit this VBA to only changes to that checkbox and cell...

I normally use a string variable (Var_MsgText) as an input to message boxes but I'm currently writing my biggest piece of code to date that has multiple subs that all use message boxes. I don't want Var_MsgText to be a public sub as that would risk incorrect carry over of the content between...

:confused: I am trying to code a pop up when the user deletes "Pending" Column M. I have searched for samples where; entry was deleted & the message had Yes/No response. I have a previous message saying "Two appointments were scheduled on your calendar previously. The first appointment was a...

Hi, I have a databook with a large number of tabs that we use check figures to ensure consistency from tab to tab. These check figures are just a simple sum function that also subtracts from another tab's subtotal and when everything is working right, should sum to zero. For example, a check...

Hello. When opening Excel files that contain links to other files, I often get a message in the lower right of my screen that says "Linking: (file name)" with a status bar (please see attached photo). This would not be a problem except that Excel seems to "pause" at this point for several...

I’m trying to use a msgbox to provide instructions if validation criteria are violated. I’m able to get the validation configured, but I would like a different message box to appear when the entered data is outside the validation criteria. For example, the validation criteria require the...

RE: Stopping macro execution without generating an error message.... This code displays a userform every 5 seconds t = Now() + TimeSerial(0, 0, 5) Application.OnTime t, "RepeatMSG" And the macro which displays the form: Sub RepeatMSG() Userform.Show t = Now() +...

Hey guys i have this code in data valididation. this basically does not allow a user to enter any data in Range R11:R30 if column O and P does not have data =COUNTBLANK($O11:$P11)=0 So for example : If O11 has data in it. P11 does not have any data in it. Now if i try to type any data in R11 ...

MrExcel Community, I have a macro-enabled workbook with several event procedures. When my workbook re-calculates, I'm getting a message dialogue that has a single word, "Calculated". When I search my entire project for the word "Calculated" I can only find that in one comment. I checked for...

How can I create a msgbox with Onkey code below. I want to create a message that says this function is restricted. Application.OnKey "^n", "^n"

Dear MrExcel community Challenge I would like to create VBA code that results in a popup message after particular calculations have finished (which are part of a existing VBA code). The wording of the message depends on certain cell values. The message will also have to include certain cell...

Hi I have the attached table. When user press submit button, I want to display the following message Based on the column C, "Add or Remove": Thanks for your license request. You have requested to add the following modules: Text1, Text3, and Text 4 (Quantity 5), Text 5 (Quantity 5) You...

Hello, I am trying to create an excel function that will identify two specific words embedded in messages of varying lengths (that I scraped from a message board online) and delete all the text in between those two words. Specifically, the message board that I scraped the data from allowed...

I am trying to record a macro wherein I am importing stock market data of Nifty fifty stocks from NSE website: https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm However, the destination cell only displays the following message "no data". Could you please tell...

I have a sheet as set out below. Is there a way or a code that will automatically send an email a week before the date in column B with a message of my choice? Thanks. ​Excel 2010 <colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum=""...