HELP Re entering Data to a previos cell using Excel Userform

[eddyrcabrera79]

Hello All,

this is an example of what I need

I have 2 columns (Name and Age) in an Excel Doc. There is already data on those columns. What I would like to know is, if there is a way for me using an Userform to Re enter the Name of a client that was previouly typed wrong instead of me going to the excel doc and change it from there

Thanks In advance

[dwint]

Try using excel Form, if not availabe in your Quick Acces Toolbars (most left top in excel application), then you should activated it first.

This tutorial using excel 2010, same as which your used to.

(1) from ribbon File, choose Options
(2) in excel options, choose Quick Access Toolbar
(3) in list "Choose commands from", choose "Commands not in the ribbon"
(4) find "Form..." and click it
(5) in list "Customized Quick Acces Toolbar", choose "For all documents"
(6) click "Add"
(7) click "OK"

Once its appears in most top left application, click any cell in table, then click Form, you can add, edit, or delete any data into table.