you use an excel form for user input - so put the two buttons onto the form.

for the decline, why not open a second userform with an input box -
multirow - for the user to enter any explanation

"sam" wrote in message
...
Hi All,

I want to design two buttons, "Accept" and "Decline" in my excel sheet. If
I
Hit Accept, I want it to populate the access DB If I hit Decline, I want
it
to display a Popup window where I can input description(about reason to
decline) and thereafter store it in a seperate excel sheet.

PS. connection of excel and access is done and, i will be hitting the
Accept
and Decline buttons once I have the user input through an excel form I
created, which would be mailed to me as an excel attachment.

I hope I made it clear.

Thanks in Advance