ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   'Find' textbox value macro (https://www.excelbanter.com/excel-discussion-misc-queries/177231-find-textbox-value-macro.html)

D

'Find' textbox value macro
 
I need to have a macro or code that will find a value the user inputs (in a
textbox) and finds it on another sheet in column B.
Thanks

Bob Phillips

'Find' textbox value macro
 
Look at Find in the VBA help. It does what you want.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"D" wrote in message
...
I need to have a macro or code that will find a value the user inputs (in a
textbox) and finds it on another sheet in column B.
Thanks




D

'Find' textbox value macro
 
Thanks, but that is a bit of a non-answer.

Could you or someone show me an example of the code?

"Bob Phillips" wrote:

Look at Find in the VBA help. It does what you want.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"D" wrote in message
...
I need to have a macro or code that will find a value the user inputs (in a
textbox) and finds it on another sheet in column B.
Thanks





Bob Phillips

'Find' textbox value macro
 
It is nothing of the sort. Help explains it well and you will learn much
better if you do it yourself.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"D" wrote in message
...
Thanks, but that is a bit of a non-answer.

Could you or someone show me an example of the code?

"Bob Phillips" wrote:

Look at Find in the VBA help. It does what you want.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"D" wrote in message
...
I need to have a macro or code that will find a value the user inputs
(in a
textbox) and finds it on another sheet in column B.
Thanks








All times are GMT +1. The time now is 03:40 AM.

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