msgbox formatting

Is it possible to change the a cell value using a msgbox? A macro runs and asks user if the quantity in cell is correct. If user says no, it will point to a new macro to change cell value. But it does not work. The cell with which the qty is in will constantly change as the main macro pulls...

Hello, I am attempting to create an error message msgbox in an Excel workbook/worksheet. I have the coding to create the msgbox but if the error is on the worksheet multiple times, it shows the error multiple times. I have tried using alreadyprompted coding to stop this action but I'm having...

I would like to only allow the user to enter a date in the inputbox in the format of 'mm-dd-yyyy'. If they do not I want to send msgbox. Here is what I have, just am unsure of how to get the validation. Sub Populate_Date()On Error GoTo NotValidInput Dim myvalue As Date myvalue = InputBox("Enter...

Hi, I need the message box to display the content "Date 14/2/2105 has been selected". I have used the below code and used LDDate function to get the date. Code: MsgBox ( "Date" &LDDate1.DateString &"has been selected",vbOKOnly ) I'm getting the error notification stating "Complier Error...

Hi All, I've a message to be displayed on a button click. The below macro is assigned. Sub getmsg() MsgBox "The store " & Range("C7").Value & " is from " & Range("I3") & " and the sales is " & Range("C9") End Sub What I need is if the sales>=40000 the sales value displayed shpuld be green...