Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a form for search text in active sheet then got to selected
hi
iam a newby in vb editor could some pls help me to make this form any help will be much appreciated toe :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a form for search text in active sheet then got to selected
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 :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a form for search text in active sheet then got to sele
"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 :) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a form for search text in active sheet then got to sele
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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search form in sheet | New Users to Excel | |||
Automatically Display a data input form when active sheet changes | Excel Programming | |||
How to Create a Search box and button for text information in an excel sheet. | Excel Programming | |||
Create Macro - move selected rows to new spread sheet | Excel Programming | |||
use a txt.value on a form to search a sheet | Excel Programming |