hi, can you help me with my sample search form? i want when i afterupdate the textbox4, it will search in sheet1 and populate in their corresponding textboxes else msgbox will prompt "No records found!".
thanks in advance.
hi, can you help me with my sample search form? i want when i afterupdate the textbox4, it will search in sheet1 and populate in their corresponding textboxes else msgbox will prompt "No records found!".
thanks in advance.
Hi, siobeh,
when inizialiszing the UserForm I had one more Textbox being set to Enabled in order to get the code working (at least wiuth my Version of Excel). And I donīt understand why you use AfterUpdate and not Exit but whgat do I know about the fancy world of VBA?
The code for the eventPlease Login or Register to view this content.
I find it irritating to have Textbox4 labelled D search in Column A and have all textboxes report text that doesnīt suit their column names.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi,
new thread started at http://www.excelforum.com/excel-prog...nd-update.html.
Ciao,
Holger
Sorry for double posting, thank you so much Holger. I've now marked this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks