• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search Value in Cell Excel Using VBA Macros

A

asparagus

Member
Hi Master,

i try to make function search with useform and show the result using VBA excel, but there is found problem when i try input word in textbox for search.
i hope there is master here can help me for fixing this problem.
i also alreaddy type code for this function seacrh in this attached file.

Best Regards,
AsparAgus
 

Attachments

  • Automation Database Punchlist.xlsm
    54 KB · Views: 16
To find a cell with a numeric value in an Excel Table, set the SearchDirection parameter to either of the following, as applicable: xlNext (SearchDirection:=xlNext): To search for the next match. xlPrevious (SearchDirection:=xlPrevious): To search for the previous match. forpc.onl jiofi.local.html
 
Last edited by a moderator:
Dear @isabellone ,

thank you very much.
actually i already set up as your mention but still found error.
1. when process search data in this area, shown error pop up "Run time Error 91 : Object Variable or with block variable not set"
73604

event though i have followed source code from other excel with same function.

i attached my revision code and file i follow
 

Attachments

  • Automation Database Punchlist.xlsm
    84.4 KB · Views: 8
  • Fully-Automated-Data-Entry-Form-in-Excel-Part-5.xlsm
    44.6 KB · Views: 8
You must log in or register to reply here.
Back
Top