Edit data via a form after another form has written it to a sheet

voutsy · Mar 3rd 2006

Hi again,

Ive got my form working ok however once the form is filled in and the user presses the button to write that data to the spreadsheet. Id like to make it so that they are able to edit the data without having to type in the spreadsheet. (ive found that the users random spellings wreak havoc with my formulas!).

Ideally id have it so that the user could select a line from the spreadsheet and hit an "edit record" button that would then open that line of data in the form that created it.

or,

If the edit button could open a form similar to the form found in the Data/Form menu but with drop down menus for them to select corrections from rather than have them type them themselves.

Are either of these options even possible?

Regards
Damian

Dave Hawley · Mar 4th 2006

Re: Edit data via a form after another form has written it to a sheet

Can you not run a spell check, via VBA code, when your userform closes?

**royUK** · Mar 4th 2006

Re: Edit data via a form after another form has written it to a sheet

It certainly sounds possible, but your question is too vague to provide an answer.

Quote

select corrections from rather than have them type them themselves

I would suggest if you are going to offer limited answers then use comboboxes in the original form to limit the choices.

Edit data via a form after another form has written it to a sheet

Participate now!

Share