message box code

Hi all, Thank you in advance for your help. I'm okay with VBA but I always get a bit confused with these message boxes when they link. So what I want to do is to have a message box that pops up when this Excel file is attempted to close that says "Have you uploaded the data?" "Yes" or "No"...

I am attempting to have a pop message display when users of a certain form "X" out of the form. Below is what I came up with but it does not seem to be working: Private Sub IntroUpdate_BeforeClose(Cancel As Boolean) Call MsgBox("User closed the program before any formulas were updated."...

Good afternoon, I was wondering how I would go about adding a "warning" or "message" box when somebody clicks my command button within my workbook please? I basically want to give intructions in the box once the button is clicked then possibly a yes/no button for would you like to continue? If...

I have a message box that pops up everytime when the workbook is opened. I was wondering if there is a way to allow the user to stop this box from popping up everytime without deleting the code. Thanks, N

I am showing below a small sample of my code. I am wanting a yes no message box to popup before the rest of the code runs. If yes then code runs if no it cancels out the macro at this time. Im not sure how to add it. Thanks

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...

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...

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...

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?

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 =...

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...

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...

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...