pop

Hi all, I have an Excel document that I use to showcase upcoming events to other users. I'd like events that I've added recently to pop up in a message box when the document is opened. I have a recently added colum with the date that the event is added followed by a colum with the event details...

Sir, In Excel i want pop up message whenever the particular cell value has changed. The cell value is changed automatically while changing the value the pop up message appears in front of the screen.

Hi folks, Trying to do a simple hyperlink so I can link to the first error value in the range. Formula is {HYPERLINK("#"&CELL("address",MATCH(TRUE,ISERROR(range),0)))} I keep getting the "we found a problem with this formula..." pop up. Seems to be the "#"&CELL("address"... portion, which...

Dear Sir I make Invoice in excel and i need a pop up box with message "E WAY BILL REQUIRED" when below conditions are met When Total INV VALUE cell "L44" >= 100001 and CGST Value cell "L42" =>1 then box should pop up In the same Invoice When "IGST" value cell "L40" >=1 and Inv Value "L44" >=...

Hi Mr Excel and hope you can help me please? As a relatively newcomer to VBA, but being quite good with excel, I need to create a form that requires a series of Yes/No inputs (Yes/No drop downs) Based on some of these inputs I need a dialog box to pop up giving guidance to the user of the...

I've managed to get to the active window ( the pop up window) but am unable to access information in what appears to be a table within ( the table doesn't have a name and only thing to go by is classnames... attached is the html / jsp code would appreciate some help here pls... < body...

Hi all, Is there any possibilities for the below. I need to get a pop message saying that "Confirm" while sending an email if my subject contains only with "IAH".

Good evening Mr.Excel first of all I would to thank you for all video and forum that you have upload.\ I have questions regarding filter. how to filter large amount of data using macro when I trying to do macro it keep on pop up with (Too many line continuations) & compiler error what is...

I have a Data Validation - List with 15+ options in the data set. I would like the same pop up message when 2 of the set are chosen. Ideally, upon clicking "OK" on the pop up message I would like it to take me to a different tab within the workbook. Would this require a Macro? Or be done within...

I have F2 returning True and False depending whatever conditions are met, and I want a pop up to appear asking user to enter date that will appear in G2. I want to make a VBA script that does the following: If F2 is TRUE, then a Pop Up appears prompting user to input a date in format...

Hi all, Hope someone will be able to help. I am below beginner with VBA and what I'm trying to do is starting to frustrate. I have a form for a customer to complete. When a number < 5 is entered into a specific cell I need a pop up to come up saying "Please provide key improvement" This would...

Hi simple one I think. I am trying to have a pop up msgbox appear if a cells value = yes. any help please.

I have a line of code that was looking at the beginning and ending spreadsheets, but now they are adding more spreadsheets so instead of certain sheets defined I would like it to pop up a input box. Here is the code I have currently: "=IF(ISNA(VLOOKUP(C2,'12-31 TO...

I have a button I am putting on my spreadsheet to pop up a userform. The userform has a drop down of names and 6 text boxes. I want the inputs from the userform to put values in cells when the user clicks "Go". The following code isn't working Here's the button code to get it to pop up...

I have a button I am putting on my spreadsheet to pop up a userform. The userform has a drop down of names and 6 text boxes. I want the inputs from the userform to put values in cells when the user clicks "Go". The following code isn't working Here's the button code to get it to pop up...

Hi All, I have the formula =COUNTIF(C4:P29,"POP") that counts all values of the POP. Now on the spread sheet I use the words POP with a number preceding it to indicate another variable. For example, I write in that range 1POP in one cell, and another then 2POP and so on until whenever. So...

Hi trying to complete a vba code that I am working on. I need to add small vba pop box. Need a pop up box saying "Enter check #" and the number I add will always go into cell E2. Any help thanks

Hi Everyone, What I am trying to do is this. for example in my sheet.. cell A24 needs an item# or SKU if you wish. Once that number is entered, I have cell B24 vlookup the description from another sheet and autopopulates it, also cell c24, looks up the price. Cell D24 is the QTY. Is it...

Hi, I have written the below code to search a value and if found remove the entire row and if successful pop a message advising the record has been deleted. I have two problems: 1. When there is no data the message will still pop up confirming something has been deleted which isn't the case...

I have automated some excel sheets to be emailed. However I get the following pop up for every email. How can I automate the "Allow" button in vba script. *************************************** Microsoft Outlook A program is trying to send an e-,ail message on your behalf. If this is...