Guys, have another hard one for you.
Sheet 1 contains Button 1 which initiates a simple user form.
Sheet 2 contains data range with columns: Account Number, Account Name, Account Code ets.
What I cant figure out is how come up with a makro which would do the following: every time I input Account number or account Name or Account Code (any of those or if account number and account code are inputted - use both as a search criteria) I want to have the account that match the criteria above to be shown in the Listbox below (not sure if it should be a list box or some other element).
If someone is interested in the task - please respond to the thread - will email detail
I would appreciate any help or suggestion.
Thank you
p.s. Using Windows XP with office 2007
Sheet 1 contains Button 1 which initiates a simple user form.
Sheet 2 contains data range with columns: Account Number, Account Name, Account Code ets.
What I cant figure out is how come up with a makro which would do the following: every time I input Account number or account Name or Account Code (any of those or if account number and account code are inputted - use both as a search criteria) I want to have the account that match the criteria above to be shown in the Listbox below (not sure if it should be a list box or some other element).
If someone is interested in the task - please respond to the thread - will email detail
I would appreciate any help or suggestion.
Thank you
p.s. Using Windows XP with office 2007
