messagebox

Hello MrExcel, excuse me if I make a mistake with the language, because English is not my own. I want to press that command button that pops an InputBox and put a number in it, like the picture. That happens in sheet "Sizes". Then I want that value to be searched in Column A of the sheet...

Hi, I am trying to create a MACRO that based off two different times that the user inputs into a message box will automatically create a thick bold border. For example: <tbody> Line Time Name Age Destination 1 9:15 Chris 21 NV 2 10:15 Janet 22 NY 3 11:15 Lura 34 CA 4 12:15 Matt 52 CO...

NEED URGENT HELP! HELLO I have been trying to find a way to get this worked but have been unsuccessful. I am trying to get a pop message when duplicate values are found in Column C which generates a unique code (only numbers) when values in column D,E,F,G,H,I,J,K and L are inserted ( in the...

Hi, I have 4 sheet in my excel file, I wish that when column O value in Overall sheet is equal to Ni, it will copy the row to Ni sheet When column O value in Overall sheet is equal to NiAu, it will copy the row to NiAu sheet. When column O value in Overall sheet is equal to NiPd, it will copy...

Hi, I wish to display a different message box when it meet the following requirement: 1. When textbox8 value less than 3, message box will show textbox8 is out of range, do user want to continue store the data, if user hit yes, then will continue store the data but if user select no, will ask...

I have a macro that runs and throughout the macro the user is presented with several vbYesNo message boxes. However, when they make their choice on each one, each message box stays displayed on this screen. Once they pick Yes or No (or Cancel), I would like the message box to go away and the...

Hi everyone, I have created a macro that should go through each row of a worksheet and look at two columns for specific values. If these values are in a row, a message box should appear asking to confirm that these details are true. If you click yes, the macro will continue, if you press no...

Hi, I need to change the msgbox,inputbox theme color.. for example : i have 6 msg box i want them to be in white and red color.. Could you please help out.. Thanks in advance

Hi, I need to change the msgbox,inputbox theme color.. for example : i have 6 msg box i want them to be in white and red color.. Could you please help out.. Thanks in advance

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

Hi All. Just wondering if there's a way in VBA to turn off all messagebox bleeps and sounds for a workbook... or to turn off each messagebox bleep individually. (I don't mind if the whole workbook runs silently to achieve this). I have excel 2007 and windows 7.

Hi there I wish that a message box to appear if no option is selected: - if txtCh1 = true and opt 1, opt2 or opt3 is not selected then msgbox (please select age group of child / adult dependant) - if txtCh2 = true and opt4, opt5 or opt6 is not selected then msgbox (please select age group of...

Hello, I am looking for a way to display a message box in VBA that will not provide any options (i.e. Ok, Cancel), but will just display a message to "Please Wait" while another process is running. I would like the message box to be cleared when the process is complete. Any good way to do...

;)how many words can a message box in excel contain…? The one that is used to pop up when the macro runs???? Thanks Excuse me for my ignorence....:eeek:

I have a macro for a new wt. form that I want to display a message if a range is below a negative value of another cell. But I can't seem to get it to work. I think the problem is in the part that I highlighted in red below. This is what I have: Private Sub Workbook_SheetChange(ByVal Sh As...