message

  1. A

    Help with IF formula

    I am trying to develop an IF formula. I have 4 cells with eother "yes" or "no" in them. I would like a formula that looks at the 4 cells and returns a message in another cell of "test" when 2 or more of the cells have "yes" in them. Can anyone assist me?
  2. R

    Macro with Message Box for Date Greater Than Today

    Hi there, I need a VBA to be used in Excel to check a couple of columns (F:F, H:H, N:N) to see if any cell in those columns contain a date that is greater than today and pop up a message. Could you please help? Thank you.
  3. K

    Pop up message box

    Hello all, I have a workbook that uses multiple command buttons to get to the user forms and writes data to multiple sheets. I was wondering if there is a way to get a message box to pop up when I click on my midnight command button and "01" is displayed in cell "C4" on the main page where the...
  4. O

    error message

    i kept getting this message whenever i try to unprotect one of the sheets i was working in excel today. it said this "the password you supplied is not correct. verify that the caps lock key is off and be sure to use the correct capitalization"....but the password i encrypted on are NUMBERS! does...
  5. L

    custom format, M has to be "M"

    Hi I have number between 1M to 10M. So I wanted to format to show 1 M instead of 1 000 000 So I went to format cells-->custom and typed #,, M But excel gave me error message I had to write it like this #,,"M" Why is that? If I wrote #,,K excel wont give me error message. So only when I...
  6. K

    yes/no pop up message box

    Hello everyone, I have a command button that opens up a user form, I would like to add a yes/no message box to the command button and when cell "A4" =01 (01 representing today's date). My message would read"do you want save the data and delete before entering new months data". If yes is...
  7. N

    Message Box Pop up twice while closing workbook event

    Hi All, I am using below code to save the current file in another location and also want a pop up message if user want to save a copy of file or not ? but every time I am closing the workbook the message box pop up twice. Can anybody help me out what mistake I am doing ? Private Sub...
  8. L

    replacing = with '= works but not '= with =

    Hi I have several formulas in different cells. I wanted to show the formula not the value so I thought of adding ' to = I went to Home-->Find and replace--> = with '= It did work Then I wanted to do the reverse and replacing '= with = but I got error message saying could not find '= Is that...
  9. B

    Opening a Message based on file name

    Hi Gang, I have a excel sheet that opens with a message box. The sheet is a template and is used to create other sheets with different variables. My question is this how do I have this box open whilst the sheets name is "Auto Blank feed sheet" and not open when the sheet has a different name...
  10. R

    Event codes with two conditions

    Hi, Can you please help me get an event code with two conditions to generate a message for two scenarios as follows? 1) I am trying to translate this formula into VBA: IF(AND($A1="Home",$B1="School"),"Invalid Combination","") I want the event code to check these conditions for rows 1 to 20. I...
  11. R

    Macro for Message Pop-up

    Hi, Can you please help me with a macro that pops up one message when we go into a sheet and another when we move out of that sheet or close the workbook? In case this is too hard, I can use just the one message. I also need help adding this macro to some more that already exist in the sheets...
  12. W

    runtime error '-2147217900 #80040e14#'

    Hello, I've been trying to retrieve some data from an Access database, but I'm getting the above error message followed by 'Syntax error in ORDER BY clause.' Sub LookIntoAccess() 'This macro opens the Database From Excess.accdb database, creates and runs an SQL query. 'Then, it copies...
  13. S

    "Be careful! Parts of your document may include personal information that cannot be removed by the document inspector"

    Hi all I am building a new spread sheet and have included some code that when a cell changes, it puts the date and time of change in another cell - the code is below, used it before and it works as well as always. Unfortunately I have a new laptop and when I save the file, which now has the...
  14. J

    Pop up message

    Hi, have these codes to remind me bill payments (this workbook has two sheets) the problem having if I am working the other sheet when times for the pop up get error message is there any way the message pop up even I am the other sheet. codes: Sub popup()Dim lstRow As Long Dim i As Long Dim...
  15. A

    Error message: "expected named parameter" when using AllowFiltering:=True

    Hi, I'm a bit of a novice when VBA and have tried a macro that removes a password from a locked excel sheet, does an action and locks the sheet again with the password. I seem to be unable to enable filtering and sorting, getting the error message "expected named parameter". Is anyone able to...
  16. C

    Display message based on cell value

    Hello - My worksheet has a set up in which users essentially put a value in column A, a value in column B, and then Column C = B-A. Each time a new value is calculated in column C, I want a message box to pop up - I need to it give one message if the value is < 8.0, and another message if the...
  17. A

    code show warning message about brands

    hello i have data in sheet1 begins range from a2:c10 and userform contains 3 textbox the column c contain values when i fill data in textbox3 and press enter i would show the message " avalible is 200 or 300 or500.etc if the entered number in textbo3 more than what in column c my...
  18. L

    saveas workbook in vba

    Hi When I run the code below, I get this message But that defeat the purpose. I mean, if I entered file name as Hello.xlsm, sill I get that message. How can I improve that code? By the way, if I save the file as "*.xlsm" before running that code and then when I run the code below, I wont...
  19. L

    my1 is not accepted as macro name

    Hi Not sure why My1 is not accepted as macro name. I opened a new excel file then went to developer--> record macro--> then typed my1 as a name for the macro but got error message. Thank you very much.
  20. M

    Clear content of several ranges (inc Message)

    Hi, For the life of me this doesnt work, any ideas? Many thanks Sub Clear_Estimated_Hours() Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to continue ?" ' Define message. Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons. Title = "Delete...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top