msg box

Help again: I'm trying to allow a user to decide not to delete a row in a protected table (part of a macro) if they click Cancel in a msgbox that pops up. I was able get the msgbox to pop up when the RemoveRows sub is run, but can't make it exit the RemoveRows sub if the user clicks Cancel...

I have a message box and I what to know the amount of doors the cabinet has. However, I don't know how to change the button options from yes and no I would like the options to be "One" and "Two" Door_message = MsgBox("how many doors does the cabinet have", vbYesNo) If Door_message =...

:confused: ok if i have 5 rows A1= 7 check the row b1:z1 and if any cell greater the cell A1 >7 return msg over limit same for the rest of the rows A2= 5 A3= 9 A4= 6 A5= 8 any help would be great :confused:

I am using a message box that pulls in a variable, I would like the variable to be displayed in Bold, can anyone help. Thanks.

Hi I've created a macro within excel 2010 that adds a new tab called 'Data' into my worksheet. The main analysis of the worksheet is now run from this 'Data' worksheet. My problem is if the 'Data' worksheeet has been created already, and the Macro that creates it is run again, by...

Hi, Just been asked to help and VBA is new to me, can you help? I'm running this sub as a tally which works ok :) Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$T$10" Then Range("S10").Value = Range("S10").Value + _ Range("T10").Value End If End Sub I need help...

Hello, I want to make a message box that says the following: "The system took 25 seconds to process." Where the 25 is a variable. I have the following code already. Sub Time() Dim t as Double, x t = Timer For x = 1 to 10 Blah Blah Blah next x MsgBox Timer - t End Sub As the code stands, I...

I am trying to force a user response to a cell, when the user leaves the cell blank and tries to navigate to another sheet, the message box would remind them of required entry and return to the sheet and cell. I have set up on deactivate sheet to run message box when cells are false which...