How to delete a row using a command button

Hi all,

I know that this may seem a little strange to request as you can just select the row and delete it, however the sheet is designed as "idiot proof", so I would like to implement this.

Basically, I have a box which states "If you need to delete a row due to incorrect entry, please type the row number here (next cell), and click delete".

I want to know if by using VBA, you can reference the number entered in the cell, and use this to determin the row in which we are required to delete.

Being that I am still learning VBA, a coding example would be very helpful if anyone has it.

Many thanks,

Andy.

Maybe:

Please Login or Register  to view this content.

Hi John,

Thank you for the response. I appreciate that this may make total sense, however I am a total novice to this.

All I have is an empty cell which I would expect users to enter the row number. Do I need to create a text box or something for them to enter this number into?

My thoughts are have an empty cell for the user to enter the row number in, then next to that a command box which says "Delete".

If this in not the way, please could you advise what is required in order to make this work?

Many thanks in advance!

What is sheet is the empty cell in and what is the cell address?

Currently I just have the sheet as Sheet3.

I would like them to enter the row number which they would like to delete into cell J6. I then have a command box next to that cell which says Delete which I would like to attach the code to ("click button") so once they enter the row number they click and the entered row number will be deleted.

Hope this is what you were after?

Maybe:

Please Login or Register  to view this content.

Do I Alt F11 and enter this as a Module, or enter it onto the This Worksheet page?

Dont worry, I got it.

Thank you very much for your help!!!

You're welcome. Glad to help out and thanks for the feedback.