message box code

  1. A

    VBA Code to End a Macro

    Hello. I'm trying to add a Message Box (with Yes and No buttons) to the beginning of a Macro that will ask the user to confirm if they want to continue. The code below works but I wanted to see if there is more efficiant code or "best practices" I should be considering. Thank you Sub...
  2. S

    Access 2007 Display a Search Result Message after input in text box

    I hope that I do not make this sound confusing. What I have created currently works but I would like to improve it. I have created 2 tables Table 1 and a Table 2, In Table 1 is only one field "Last Name" and is a text field. Table 2 is a populated database with information and one of the...
  3. S

    Displaying A Menu Of Worksheets To Print - msg box on the fly

    Using Excel 2003, I have a nice bit of code/ macro that will display a menu (msg box) of worksheets to print as long your worksheets are visible (not hidden).....it will offer a checkbox to print. However, I would like to avoid offfering the choice to print one of the tabs e.g. "Menu" tab...
  4. J

    message box questions

    Is there a way to program a message box to become a differant color? Is thera a way to program a message box to show up a a differant location other then the middle of the screen?
  5. caritx

    Message Box help vba

    I have this code which works great but in the text I also want it to display the line count for column A and the sum of AZ Sub test() ' ' Batch test ' Dim addbatch As String addbatch = InputBox("Batch") Range("BC1").Select ActiveCell.Offset(1, 0).FormulaR1C1 =...
  6. W

    vbOKCancel use question

    Hi All, I am using the following code to alert a user that data entry which is required to generate the filename hasn't been made, and when OK is clicked a dialog box appears showing the filename which defaults to '.xls. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As...
  7. KP_SoCal

    VBA to Create Message Box when Space Bar is Pressed

    For colums A,B,C,G,H on my worksheet, I would like to create an error message when users press the [SPACE BAR] when inside any one of the cells for these columns. The message would prompt them that entries using the [SPACE BAR] are not allowed. I took a stab at this by writing the following...
  8. H

    Prompt message when workbook is opened on particular date

    Hi, i would like to have message prompted to reming user doing backup whenever the workbook is opened from 28 til the last day of the month (30th or 31st depending on which month). wha's the correct code for "date"? Private Sub Workbook_open() If Date>=28 Then Msg = "Remember to do monthly...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top