Please do NOT attach files here. State your problem. Often you will be
invited to send a file directly to a responder.

--
Don Guillett
SalesAid Software

"Kortrijker" wrote in message
...
I'm trying to make a userform to show data, but I don't know how to make
buttons in this userform active.

For instance, the result I want to get is, when I click buttens, the
criteria I select in left listbox could get into right side, finally the
'result' button will show the record according to criteria I chosed.

or when i choose 'renew' button, all criteria I chosed will be cancelled.

This is the first time I use vba, I'm trying to use loops in this
userform,
but it's really in a mess. Please help me out or give some tips, thanks.

Sorry, I won't do it again. Can I delete my attached file?
"Don Guillett" wrote in message
...
Please do NOT attach files here. State your problem. Often you will be
invited to send a file directly to a responder.

--
Don Guillett
SalesAid Software

"Kortrijker" wrote in message
...
I'm trying to make a userform to show data, but I don't know how to make
buttons in this userform active.

For instance, the result I want to get is, when I click buttens, the
criteria I select in left listbox could get into right side, finally the
'result' button will show the record according to criteria I chosed.

or when i choose 'renew' button, all criteria I chosed will be
cancelled.

This is the first time I use vba, I'm trying to use loops in this
userform,
but it's really in a mess. Please help me out or give some tips, thanks.