check excel sheets with listbox

[vijay2482]

hi,

i have two excel sheets say sheet1 and sheet2
now i want to check if the items in the listbox has a matching in sheet1 and sheet2
two conditions to check:
1)if the items in the listbox are not in both the sheets
2)if the items in the listbox is not in sheet1 but in sheet2

these two conditions has to be checked and if they are true, a warning message has to be set, saying that this item in the listbox is not in both the sheets or this item in the listbox is not in sheet1 but in sheet2

how to obtain this?

thanks in advance <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[SteveO59L]

Where is the data for the listbox ?

 

[vijay2482]

i have a userform in which i have a textbox,listbox,add button,remove button
i enter the values in the textbox and add it in the listbox
if i want to delete a value i use remove button

i guess to check with the excel, i need to store the listbox value somewhere as a temp buffer.....

if im right, how to achieve it????

thanks for the reply

 

[vijay2482]

Re: check excel sheets with listbox(Please Help)

hi all,
somebody please help me to do the above requirement......

thanks in advance