create a form for search text in active sheet then got to selected

[toe]

hi
iam a newby in vb editor
could some pls help me to make this form
any help will be much appreciated
toe

[sebastienm]

Hi
What is the difference between your form and the excel search feature (menu
Edit > Find)?
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"toe" wrote:

> hi
> iam a newby in vb editor
> could some pls help me to make this form
> any help will be much appreciated
> toe
>

[toe]

"sebastienm" wrote:

> Hi
> What is the difference between your form and the excel search feature (menu
> Edit > Find)?
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>

hi
this program iam making is for builders that find using computers is
difficult anothe.
just trying to make it easier for them
toe
>
>
> "toe" wrote:
>
> > hi
> > iam a newby in vb editor
> > could some pls help me to make this form
> > any help will be much appreciated
> > toe
> >

[sebastienm]

In this case, an easy way (if that works for you) is to create a new toolbar
where you put all the commands you want your user to access grouped together.
Then Attach the toolbar to a new blank book and distribute that book. That is
everytime the book is open, the toolbar shows up (and all of its features).
The bellow description seems long but it is in fact very quick and easy to
do... and it requires NO code.

1. Create a new toolbar
- menu View > Customize, the Customize dialog pops up
- in the Toolbar tab, click New. A new toolbar called Custom1 has been
created and is listed in the 'toolbars:' listbox. Select it in the listbox
and rename it to something like: your company name

2. Add the Find feature to the toolbar:
- still in the Customize dialog, go in the 'commands' tab. There, select
'Edit' in the left listbox, then, in the right listbox, find the 'Find'
icon+name and drag it onto the new toolbar you have just created in step1
above.
- repeat this operation for all the features your need.

3. Distributing the toolbar.
- Create a new blank book
- Display the Customize dialog (see step1).
- Attach the new toolbar to this blank book: in tab 'Toolbars' select the
new toolbar (originally Custom1) in the list and click the 'Attach' button.
The Attach toolbar pops up. Select the toolbar from the left list and click
the 'Copy' button to pass it to the right list. Click OK. The toolbar is now
attached to that book.
- Save the book.
- Distribute it as you would have done with your macro. (one way is to save
the book in the following directory on the user's machine, ie in:
C:\Documents and Settings\<useername>\Application
Data\Microsoft\Excel\XLSTART
where <username> has to be replace with user name)

I hope this helps.
Maybe someone will have a better idea.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"toe" wrote:

>
>
> "sebastienm" wrote:
>
> > Hi
> > What is the difference between your form and the excel search feature (menu
> > Edit > Find)?
> > --
> > Regards,
> > Sébastien
> > <http://www.ondemandanalysis.com>
>
> hi
> this program iam making is for builders that find using computers is
> difficult anothe.
> just trying to make it easier for them
> toe
> >
> >
> > "toe" wrote:
> >
> > > hi
> > > iam a newby in vb editor
> > > could some pls help me to make this form
> > > any help will be much appreciated
> > > toe
> > >