I filter my data based on entries in field 8 and once I have that filtered I want a message box to pop up to let me know if there are any new entries.
The filtering works, and I know that the message box criteria is wrong since cell H2 won't be blank. It's just not in the filtered range, but...
I'm new to this forum, but I feel like this is a great place to get help. I am trying to find the correct If Then coding to use that will pop up a message box if there is no inverse to a matrix, but everything I have tried has failed. The closest I have gotten to something that works...
How do I do the code in the sheet itself in the "view code"
when the value in column K (any row in the column) is less than 10,
a message will pop up to the screen that says - "10 days left until expiration"
I would appreciate your assistance!
We're currently using a spreadsheet to record and track training requests, and have a column (W) to note if a learning request form has been completed. I'd like to add a VBA to send an email if the cell in column W says "Yes" - Would also like a pop up box to prompt this ("Would you...
I'm getting this problem "OUT OF MEMORY", when I run my vba.
My vba basically takes various things from a online csv which grabs time, year, # of ad clicks, weather, and, it takes it from there and pastes it into my document every 5 seconds or so.
So I have an up-to-date dashboard of...
I have a spreadsheet where the first sheet is a form using ActiveX controls (ComboBox, TextBox, and CommandButton). The ComboBox is a part number and the TextBox is a quantity. Once these are filled and the CommandButton is pressed, the information is sent to a master sheet with all entries...
I must be doing something stupid because I can not determine why this code is not working. There was another post last month (Pop up box based on certain values within cells) which is very similar to my needs. I need to have a popup message box to inform the user the value has to...
I have a load of text data which I need to read through to confirm if its relevant or not. I want to display the text from each cell in column D in a message box and then click ‘yes’ or ‘no’ depending on its relevancy and then move onto the next cell down, when i click yes or no i want it to...
Hi all you wonderful Guru's,
I have a Macro with several calls within. How do I place a message box in before the last call to either yes run the last call or no to end the macro right there?
pop up a msg box yes or no to either continue to the next call or end the...
Ideally I would like the message box to display whether any discrepancies were identified in sheet 3.
The data in sheet 1&2 should be identical, so when the macro is run the results in sheet 3 should show no data because there is no discrepancy. Now, if there are discrepancies between the data...
I need help on VBA for the following requirement.
Pop up message with 3 button of choices
1. Overwrite file
2. Save as different file name
3. Cancel operation.
Thank you so much for your help.
I’ve been given the code below which seems to do almostexactly what I want it to do but I’d like to make a couple of changes which iswhere I’m stuck
AsI understand it this code identifies if a cell has been changed then if thetotal in row 21 is higher than that of row 23 provides a...
I don't really know if this is possible or where to start (which is probably why I can't search for it very well)
I have a workbook with a number of identical worksheets (one for each month) - each worksheet has data that can be entered into about 30 columns via drop down. Each column then...
I want a box to pop up when a worksheet is activated to alert the user to delete the sheet if they are not using it. So far I have:
Private Sub Worksheet_Activate()
MsgBox "Not using Census Data? Delete this tab!", vbInformation + vbOKOnly, "WARNING"
I'm feeling a bit stupid -...
Hi All, despite much searching and trials I almost have what I need but cannot work out the last bit.
I have 7 sheets as part of a training course session for each day of the week and two other sheets that have various stats on them drawn from the formula on the Monday to Friday sheets.
Hope someone can help with what I trying to do.
What I would like (and have no idea where to start) is when a user updates a cell in my worksheet that the code looks at the cells at the top of that column and if one is greater than the other produces a message box.
Ie: User updates...
I have multiple worksheet event macros on my sheet. When selection Y/N is unlocks or locks respectively and a message box appears based on the selection. For some reason my macros 3-6 repeat the previous message boxes starting with the message box in the 2nd macro. The first and second macros...
Thank for for helping all those who are in need!
I created a macro where it looks at the all required fields and then emails to approver. I have the same command button to trigger email function from requester to approver to final user.
My issue is I need approved message box only to...
HELP PLEASE. I don't think like a programmer, hence my question. I have an excel spreadsheet and I need to add a pop message based on the value of cell (for multiple cells). I know this is easy for most. I'd appreciate all the help I can get.