Finding Info in Userforms

[xirokx]

Hi,

I am a total noob when it comes to userforms. So far I have learnt the
basics like inserting a userforum, renaming text and command boxes,
assigning some vb language to the cmmd buttons and running the
userform.

Now I would like to learn how to implent the "find" command into my
userform?

Also I would learn how to implement the "edit" feature to my userform
so that it changes a record and saves it?

I have no knowledge of VB and I am totally new to this.

Please help

Thanks in advance.....

 

[Norman Jones]

Hi Xirokx,

See Debra Dalgleish's Userform tutorials at:


http://www.contextures.com/xlUserForm01.html
and
http://www.contextures.com/xlUserForm02.html

To find and edit records, perhaps Excel's built in Data Form would suffice?

For a more sophisicated alternative to this DataForm, see John Walkenbach's
Enhanced DataForm, which may be downloaded, free odf charge, at:

http://j-walk.com/ss/dataform/index.htm

 

[xirokx]

Hi,

I have taken a look at those websites and they don't really help.....

So to clarify

I would like to add a find button to my current userform and attach the
relevant VB code to it thats finds record using the ref as a key. But as
I am a total noob dont have a clue how to go about doing that? Can
someone kindly help?

Also would like to do the same using an edit button?

Thanks in advance....................