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

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

Thanks for your Input Patrick.

I am taking user input through excel forms which I want to approve. Its on
me to accept and decline , So once they input the details through excel
userform, I will get an Email with the user inputs as an excel attachment.
Once I open the Attachment I want a Accept And Declien button.

I Hope i made it clear.

Thanks in Advance


"Patrick Molloy" wrote:

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

Hey Patrick, doing it this way would open excel every time I open excel.
Even If i open excel for doing something else

"Patrick Molloy" wrote:

you want to create a workbook with the two buttons, save it in the Excel
Start folder so that it opens automatically when excel starts, so that the
code is available to you.
just link the buttons to the code you've already written.



"sam" wrote in message
...
Thanks for your Input Patrick.

I am taking user input through excel forms which I want to approve. Its on
me to accept and decline , So once they input the details through excel
userform, I will get an Email with the user inputs as an excel attachment.
Once I open the Attachment I want a Accept And Declien button.

I Hope i made it clear.

Thanks in Advance


"Patrick Molloy" wrote:

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