1. B

    InputBox Error if left blank or cancel is selected

    Hey all! I have been trying to figure out the code to give an error message when the user leaves it blank or hits cancel with no luck. Thanks for the help!!
  2. S

    Syncing a Shared Workbook Prior to Saving

    Hi, I'm not really sure if this could be done; but I was wondering if there is a way to sync a shared workbook with all users before saving the workbook? At present, I am building a simple worksheet for team members to record the times they will be going on each day. We are limited to the...
  3. E

    Cancel message that file is open

    <tbody> Cancel message that file is open That message shows the work file and hides the form What is the best way to ignore the appearance of that message when you open the work file and it is open by <tbody> Cancel message that file is open That message shows the work file and hides the...
  4. J

    Overwrite msgbox Yes/No issue

    Hello I am in need of your help, I am trying to add a message box popup in VBA that when a user selects file>save or ctrl+s, it prompts them with a message box that states "Do you really want to overwrite this file?" Yes button to continue to save, No button to cancel and close the message box...
  5. J

    Trouble with InputBox

    I am capturing a value using a InputBox command. The problem is that if the input is 0, the input box returns FALSE and if I press cancel it still returns FALSE as output but with Runtime error 13, Type mismatch. My code for cancel is working because of both outputs being FALSE. How to go back...
  6. C

    VBA Textbox Requires @ Symbol

    - I have a userform textbox in which applicants input their email Question - I want the @ symbol to be mandatory - I want a message box to show if there is no @ symbol inputted My current code is as follows (I have both a Change and Exit sub, I know I can dump them into one Exit sub, but I...
  7. K

    VBA Help: If workbook is open return an error with option to retry

    Hi, I have two workbooks, WB1 & WB2 as an example. WB1 contains my UserForm and WB2 contains the master data where the entered information from the UserForm is placed. My issue is that multiple people need to submit data via the UserForm yet if the 'Submit' button is pressed by two or more...
  8. K

    VBA Help: Check cells are completed before submitting data to workbook

    Hi, I'm new to the VBA world but I am getting there slowly. I have created a UserForm with a number of text and combo boxes. I am currently stuck whilst trying to sort out the command button. :confused: What I want to happen is that when the 'Submit' button is pressed, it checks that all the...
  9. Michaels

    Enable Save But Disable Save As - VBA

    Hello, I am trying to use the following code for disabling "save as" in workbook_before save event for preventing the user to save a new copy of my workbook. However, I want to enable "save" (as in when someone presses Ctrl + S). Here is my code: Private Sub Workbook_BeforeSave(ByVal...
  10. R

    RUN-time error '-2147024809 (80070057)

    Hello all, Please help! I am stuck on how to get round with this problem. I kept getting this error message when I click "OK" from the userform. Runtime error '-2147024809 (80070057)' The item with the specific name wasn't found. when I click debug, the code it highlights is...
  11. H

    Values entered on double-click

    Hi everyone, I'm trying to figure out how to add two separate values with double clicking in cells within a specified range. I found a string of vba that helps me do one of the values that I'm looking to populate but I know that you cannot enter two of these strings into the background of a...
  12. E

    Hide Ribbon

    Hi, I have found the following command to minimize the ribbon and have added it to my Workbook_Open commands Application.SendKeys "^{F1}" Can I revert back to the ribbon being static using another command to cancel out this one for a Workbook_Close command Many thanks
  13. M

    BeforeSave Check two ranges cancel if one is empty and the other not

    Hi, I'm fairly new to vba and have been trying to create a sub that when the workbook is saved it checks two different ranges. If either one is empty and the other has a value in it cancel save and display a msg. if both are empty or both have values continue with save. The workbook has a master...
  14. jim may

    Error ONLY when double-clicking Cat9 - RT error 91

    This code works fine when I double click on Cat1 through Cat8; But I get R/T 91 - ERROR ONLY when I double-click on Cat9 (Only). What could be my problem? TIA, Jim Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim MyMacro Cancel = True MyMacro =...
  15. J

    Insert date and initials when doubleclicking cell

    Hi guys, I hope you can help me with an issue I have. I want to a create a code for a workbook that allows me to insert date and name when i doubleclick a given cell. The output in the given cell should look like this: "John Doe, 31/08-2017". The cell range should be H:Q. The date should...
  16. S

    [VBA] update ActiveWorkbook's name when content changes via [save] button

    The following code works well to rename activeworkbook and remove the old workbook when it detects content changes. [like a time-stamp saving ] However, after execution, the Excel application itself just crashes down even "On Error Resume Next" is included. Nonetheless, I can still open the...
  17. S

    Double-Click cell to remove updated contents

    Hi, I have a sheet that has data in column E (E3:E12) I have function set so that when double-clicked, the data in that cell will copy to another cell, and the original cell will highlight (yellow). my code is below: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...
  18. F

    Vba code verify email

    Hello all What code can I use if an email is being sent from excel however instead of using the option sent i use option display but when the email is displayed the user cancel or close it therefore I need a code to Let me know if the email was sent or not. Thank you
  19. K

    Assigning If function to a Shape instead of a Command button

    I am trying to assign the following script to an Image as I do not want to use a command button. Upon running it gives me an "Object Required' error message. Kindly assist Sub SaveForm() If TextBox10.Text = "" Then Cancel = 1 MsgBox "Please enter Contribution Ref # field before saving the...
  20. W

    SUMIF criteria met or not met.


Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back