Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBA code to search for a text from a userform

Hi,
I have made a userform to deal with data from 13 sheets in a work book.

I just don't want to use usual search and find from EDIT Menu

Can any one help me by giving a vba code to find a text which meets the
search criteria like between two dates and highlight it

Thanks
Austy
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default VBA code to search for a text from a userform

Look at Find/FindNext in VBA help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Austy" wrote in message
...
Hi,
I have made a userform to deal with data from 13 sheets in a work book.

I just don't want to use usual search and find from EDIT Menu

Can any one help me by giving a vba code to find a text which meets the
search criteria like between two dates and highlight it

Thanks
Austy



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with my code for incorrect text box inputs on a userform BrianMo Excel Programming 2 September 29th 06 11:38 AM
Userform Search HelenMcKenzie[_2_] Excel Programming 5 July 28th 06 06:01 PM
Excel XP VBA code to search all macro code in Excel module for specific search string criteria Ed[_18_] Excel Programming 4 May 20th 04 02:08 PM
Excel XP VBA code to search all macro code in Excel module for specific search string criteria Frank Kabel Excel Programming 0 May 19th 04 08:11 PM
UserForm - display text message then run code Robert[_13_] Excel Programming 3 September 13th 03 11:37 AM


All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"