| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA code for search button
New to vba code,
Looking to search data inputed in a text box by a comand button prompt and then find the data in the worksheet. Please advise |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VBA code for search button
Shouldn't CTRL+F suffice?
The functionalities you seek should be well served in the ensuing dialog -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "Dylan @ UAFC" wrote: New to vba code, Looking to search data inputed in a text box by a comand button prompt and then find the data in the worksheet. Please advise |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VBA code for search button
Would really like to have a button on the sheet
that does the command, there are multiple user and most have little computer knowdledge "Max" wrote: Shouldn't CTRL+F suffice? The functionalities you seek should be well served in the ensuing dialog -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "Dylan @ UAFC" wrote: New to vba code, Looking to search data inputed in a text box by a comand button prompt and then find the data in the worksheet. Please advise |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VBA code for search button
Private Sub CommandButton1_Click()
Application.Dialogs(xlDialogFormulaFind).Show End Sub -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "Dylan @ UAFC" wrote: Would really like to have a button on the sheet that does the command, there are multiple user and most have little computer knowdledge |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make search button in the first sheet | Excel Discussion (Misc queries) | |||
| Is there a code that anables you tto search for a worksheet | Excel Discussion (Misc queries) | |||
| Search Button | Excel Discussion (Misc queries) | |||
| VBA-code for search,copy and paste | Excel Discussion (Misc queries) | |||
| Post Code search | New Users to Excel | |||
![Dylan @ UAFC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
