Find Function

K

kiza

Hi
I am trying to use the Find Function which is located within Exce
within a macro.

I have recorded the Find function using the macro recorder as show
below:

Cells.Find(What:="UNKNOWN", After:=ActiveCell, LookIn:=xlFormulas
_
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext
_
MatchCase:=False).Activate

I am using a User Form and want to allow the user to enter informatio
which they wish to delete into the user form and then activate th
macro. The macro will then find whatever information was entered in b
the user and delete it.

Does anyone have any ideas as to how this can be acheived?

Many Thanks
Kieron Whit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find copy data from a cell in Personal workbook and copy it to a cellin current workbook 14
use Find without hardcoded value but a value from a cell 1
Run macro on all sheets 3
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
macro to select a range from a set cell to a specified cell 6
Getting Excel Find to Default to Searching Workbook not Sheet 3
Using While Wend with Cells.Find 1
Find Feature with Macro 3

Top