ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VBA code for search button (https://www.excelbanter.com/excel-worksheet-functions/211508-vba-code-search-button.html)

Dylan @ UAFC[_2_]

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

Max

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


Dylan @ UAFC[_2_]

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


Max

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




All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com