pop up msgbox to add extra rows Excel 2007

[Excelnoub]

Good morning all,
I’m trying to figure out a code to do the following:

If user select “SO” from a validation list in column Q then open a msg box that will let the user insert a number in a field and when the user select “Ok” then it will add rows based on the users number input.

But it needs to be off from 1, meaning that if the user adds 001, 01, or 1 in the pop up box then do nothing. But if the user adds 002,02 or 2 it will add one row.

Example:
If “SO” is selected from column Q then,
Msgbox: “Insert the number of SO to continue”

USER: adds 003, 03 or 3 then (ok button)

VB: Adds 2 extra row “below” the selected row.

If “no” is selected from the msgbox then do nothing.

Where do I start or when could I get web info, I’ve looked but nothing to my request.
Thank you.

[Excelnoub]

http://www.excelforum.com/excel-prog...ell-value.html

this explain what I need but with a -1 but i'm not to sure where to add it.

Please Login or Register  to view this content.