message

  1. K

    Error Handling Exit Sub

    Hello, I have an OnError GoTo statement. If there is an error with the MkDir (aka, the file already exists), then I want it to go to the ErrMsg that asks if the user wants to continue or not. If they continue, the files will overwrite. If they don't, the macro ends. This is working perfectly...
  2. 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?
  3. 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.
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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.

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top