View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phendrena Phendrena is offline
external usenet poster
 
Posts: 39
Default VBA Userform - Editing Controls (Similar to Dataform) (Excel 97)

Hi there,

Would anyone please be able to point me to a guide that advises how I can
add editing controls to a userform?

I have setup a data entry userform.
I would like to add the ability to search for records and then edit and
update the records. I have the search working - it nicely populates a
seperate listbox.

What I haven't worked out is :
How to get the data back from the data worksheet and into the fields on the
userform & how to update the data and not add a new record.

Can anyone help me please?