Thread: Edit Forms
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Edit Forms

in you code to load the record, you would just use code like

Textbox1.Text = Cells(i,1)
TextBox2.Text = Cells(i,2)

then to write it back, you similar code to that which you say you know.

Cells(i,1) = Textbox1.Text
Cells(i,2) = Textbox2.Text

--
Regards,
Tom Ogilvy


"Steve" <No Spam wrote in message ...
I know how to create a form to add records in Excel. My need is to create

a
form that allows a user to edit an existing record, without allowing the
user to delete a record. Can someone point me in a helpful direction?

--
Steve