How to add yes no popup box

**Launchnet** · 01-09-2010, 12:58 AM

I have a macro that deletes the row where the active cell is on. Works perfectly.

I want to have my macro display a pop-up box that gives the user the option to either delete or not delete the row.

I would like the question to read . . . Are You Sure You Want To Delete ?

The options would be Yes or No.

I have no idea where to start.

**davesexcel** · 01-09-2010, 01:20 AM

How is the macro being activated?

**Launchnet** · 01-09-2010, 01:25 AM

Hi DavesExcel . . .

By clicking a button on the worksheet in the header. The header is made up of 10 rows and the code stops this delete row function from working if the active cell is in any of the 1st 10 rows.

All I need, is at the very beginning of the macro to have a yes no option so that the user gets one last change to not delete if the user changes mind.

**shg** · 01-09-2010, 01:54 AM

Make life simple and post the code, Matt.

**Launchnet** · 01-09-2010, 02:09 AM

Please Login or Register  to view this content.

**davesexcel** · 01-09-2010, 08:55 AM

Here is an example of a YesNo MsgBox

Please Login or Register  to view this content.

**Launchnet** · 01-09-2010, 03:44 PM

Thanks Dave . . . You all do a great job.

Works perfect.

**ebin charles** · 05-11-2010, 06:35 AM

Hey!

I applied this macro to my worksheet it works fine. But the second message
("Your Code goes here") should close automatically. This msg should popup and close automatically.

Regards
Charles

**teylyn** · 05-11-2010, 07:42 AM

ebin charles,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.