UserFrom: Search/Display/Edit

[rookie2excel]

I have been trying to add a feature that will allow me to search, display and edit data i have already input.

Is there a way to do this, or a different way to do it?

Can anyone help???

 

[Smitty]

Welcome to the Board!

Have you tried CTRL+F (Find) or CTRL+H (Find & Replace)?

 

[AlphaFrog]

There's also the Data Entry Form under the Data menu.

 

[rookie2excel]

Smitty-that works good, but i need to create a command.

This data entry form will be for multiple users that are not really tech savy.

Alphafrog- I have tried that but i can't find a way to add a checkbox that will make some tasks easier for end users.

 

[Smitty]

You can record a macro doing a Find & Replace. Then you can replace the search/replace strings with Input Boxes for your users. Here's an example:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> FindandReplace()<br>    <SPAN style="color:#007F00">'   Find a string in every sheet and replace it with something else</SPAN><br>    <SPAN style="color:#00007F">Dim</SPAN> x <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">String</SPAN>, y <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">String</SPAN><br>        <br>        x = InputBox("Replace What?", "Replace What")<br>        y = InputBox("Replace With?", "Replace With")<br>        <br>        <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> ws <SPAN style="color:#00007F">In</SPAN> ActiveWorkbook.Worksheets<br>            <SPAN style="color:#00007F">On</SPAN> <SPAN style="color:#00007F">Error</SPAN> <SPAN style="color:#00007F">Resume</SPAN> <SPAN style="color:#00007F">Next</SPAN><br>            ws.Cells.Replace what:=x, replacement:=y<br>        <SPAN style="color:#00007F">Next</SPAN> ws<br>            <br>        <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>