message

Yes, I had a dream about Excel. I don't quite know what to think about that but I'm going to just go with it. :eeek: So I woke up 45 minutes late for work today (yup, off to a wonderful start) and remembered part of a dream I had about VBA and it won't leave my tired brain. Is it possible to...

Hi everyone! In my database I have implemented a number of login features to protect the database. Every 60 days users are forced to update their password, and if they have not logged in for 90 days they are prevented from logging in until an administrator restores their privileges. In order to...

Hi all, I'm trying to make a pop up box where the message information will change based on variables. I have a database of multiple factors (the 3 I'm currently working with are (Project, report type, frequency) which are unique combination. The summary page shows these 3 factors and several...

Hello All, I am using Excel 2013 and I would like to know how to have my message box to pop up the value of a cell that has a different language. In cells C2 and others, for example I have a words in Greek. When I am entering in the words I change from English font to a Greek font and type the...

Hello, I have multiple cell to check just doing one to test at the moment. I have a date in that is input to that cell I want to run a check to make sure its 3 months in the future. If not pop-up a message box letting the user know check the date. [code] Sub check_for_errors() Dim cd As Date...

Hi i would like to have a warning message box pop up if i enter a value into a cell that matches a value from another range of cells. The range of cells with preset values in it is P3:P10 If i enter a value in the range R3:AC10 that matches one of the values in the range P3:P10 i would like...

I was trying to load a couple of files into PowerQuery today and I keep on getting this error message (Expression Error: The key didn't match any rows in the Table). Do you know what the possible causes are and how I can fix it. I even tried downloading it without making any adjustments and...

Hello, I have a spreadsheet that has multiple columns of data. I need a macro that will prompt the user to select a row, then concatenate the info into another cell. The point of this is so the data can be copied, and pasted into a label maker. This label printer only prints from its...

I have some code which works for me, but gives an Error 400 message to another remote user. MsgBox 1 ActiveSheet.Unprotect Password:="abc" MsgBox 2 Range("ShiftMonths").Copy 2 is the last message the user receives before the code fails. "ShiftMonths" is a range on the active...

All, I have a macro as shown below that keep excel in its own instance. However, if you open a workbook that has a message such as the do you want to open in read only message then that message comes up before the workbook_open event fires so its still in the same instance until the user clicks...

Hi All, I have a sheet with approximately 75K rows. My code is adding columns, formulas and formatting working great. I would like to stop the code in the middle/at specific points with a message box to allow me to do a manual edit on the sheet. For instance, have a message box pop up with...

I have a simple Yes/No message box that will exit the sub if the user clicks "no". I saw on another forum where someone mentioned that we can "add another condition to test the user's response for something else in addition to vbYes (perhaps to test for no response by clicking the X to close...

Hi Experts! I am trying to formulate the best way to create conditional formatting rules to be able to highlight the whole row based on the words found in column G. Basically, column G contains all the status of the processing of the macro. It is consist of a sentence or two. I want the rule to...

Hi i have a macro code that creates a folder by what i specify in a cell. i woud like this code to incorporate a message box telling me what folder has been created Sub MakeSubFolder() Dim lngCount As Long lngCount = 2 If Len(Dir(Cells(1, 20), vbDirectory)) = 0 Then MkDir Cells(1, 20)...

hi guys a have a range of cell example A1 B1 C1 D1 E1 if i click the button a message will tell me that i have a blank cell on range, and if theres no empty cell it will save my worksheet, thanks

Hello, I have a list of names in column A. In Cell D4 I want a message to appear if column A contains any duplicates. What formula could I use? Thanks.

Hi Team, I have the following code that returns data from the web (via Power Query): Application.ScreenUpdating = False If CheckBox1.Value = True Then Sheet3.Range("B4").ListObject.QueryTable.RefreshPeriod = 1 Else...

Hello all, Can someone correct the below formula please? Message I get is The formula you typed contains and error. =IF(AND($P$6="F1",=IF(T15>$AH$13,$AJ$12,IF(AND($P$6="F1",IF(T15>$AF$13,$AH$12,IF(AND($P$6="F1",IF(T15=$AL$12,"",$AF$12))) Maybe I need different functions?

Hi When I run the code below for the first time, I get no error message and file name would change to testing123.xlsx but when I run it for the second time, I get error message saying the file already existed. How can I change that or can I? Thank you very much. Sub savewb()...

Hi guys, Can you help me on my project. I wanted to search the exact product and if does not match a message box error will appear. I have a script wherein when i search a product and when it was empty a message box will appear saying "Insert Product" then when i search a product with a wrong...