Help with Userform

[Harry K.]

I need to setup a restricted means of allowing users to edit data in
existing cells on a spreadsheet through a macro (userform?). I want to
create a userform that will read data from these existing cells and display
their contents in a series of text boxes. The user will then have the
choice to edit any data item, if they need to, or leave the data as is. Upon
the user hitting the OK key on the userform, the edited data will be entered
in their previous cell locations.
Any help or examples will be appreciated!

Thanks

 

[skuzapo]

Hi Harry,

To get the information from a named range in your spreadsheet you can
use this:

frmName.txtName.value=worksheets("SheetName").Range("RangeName)

Then, once the user has edited the information you can use:

Worksheets("SheetName").Range("RangeName")=frmName.txtName.value

Cheers