User form & Query box

Showing 1-6 of 6 messages
User form & Query box 10/6/12 10:33 PM
This group help me a lot for ma assignment time to time, I m really happy to be the member of this group.

here again, I've some query & require help from expert of this group. I need to create a user input form.

I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) & return me with the result that "Data Available" or "Data Not Available", if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format & unique.

Request your help to get a sample sheet with the above condition, 

Thanks for help in this matter.

Thanks & Regards,
Prabhat Shrivastava
Re: $$Excel-Macros$$ User form & Query box ashish koul 10/6/12 10:50 PM
can you share the sample file

Join official facebook page of this forum @
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to
To unsubscribe from this group, send email to

Ashish Koul

P Before printing, think about the environment.


Re: User form & Query box 10/6/12 11:09 PM
Re: User form & Query box 10/6/12 11:14 PM

On Sunday, October 7, 2012 11:03:46 AM UTC+5:30, wrote:
Re: $$Excel-Macros$$ User form & Query box 10/6/12 11:18 PM

Hi Ashish,

The excel list is consists of account nos in text format in column A i.e. 052233000000056, 052233000000057, 052233000000058 & so on rest will be done by query excel forms/input box.

Prabhat Shrivastava
Re: $$Excel-Macros$$ User form & Query box 10/8/12 9:48 AM
hi Ashish,

Pl provide the solution, if you can.....