Microsoft Office Forums - View Single Post - confirmation popup on excel sheet macro

Thread: confirmation popup on excel sheet macro

View Single Post

Old

12-22-2011, 01:16 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

There are lots of possibilities...Change the line:

Code:

Ask = MsgBox(Prompt:="Is this What you want?"& vbNewLine & _
activesheet.cells(1,"F") & " will be deleted!", Buttons:=vbYesNo, Title:="Confirmation required")

Reply With Quote