accept and decline buttons in excel sheet emailed to me as attachm


S

sam

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
 
Ad

Advertisements

P

Patrick Molloy

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
 
S

sam

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
 
P

Patrick Molloy

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.
 
Ad

Advertisements

S

sam

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top