HI EVERYONE! I HAVE A SORT OF COMPLICATED QUESTION... FOR ME ANYWAY!

I WANT TO CREATE A FORM WHERE I CAN ADD EITHER A BUTTON OR TYPE A SPECIFIC LETTER TO GET THE PROGRAM TO PROMPT ME FOR A NUMBER THAT IT WILL THEN CALCULATE TO A SUM AT THE BOTTOM OF MY PAGE. FOR EXAMPLE. ITS A SIGN IN SHEET AND IF I SELECT A BUTTON OR TYPE IN THE LETTER "N" IT WILL PROMPT THE USER TO TYPE THE AMOUNT OF A "NO SHOW FEE" AT THAT POINT WHEN I ENTER LETS SAY 5.00 IT WILL ADD THAT NUMBER TO MY SUM AT THE BOTTOM OF THE PAGE.
THE SECOND PART OF THE QUESTION IS... HOW DO I MAKE A BUTTON OR SHOULD I USE A DROP DOWN LIST?

IS ALL THIS EVEN POSSIBLE WITH EXCEL????????????????

THX ALL

Howdy, and welcome to the board.

Yes, this is possible. Can you provide a sample workbook with some data in it, including what you want in the dropdown box?

BTW, it is much better NOT to use all capital letters - very hard to read.

The poor, poor shift (or caps) key!
What did he ever do to you?

Have a look at recorded macros... I understand that they fire on keypress.
(I might be (probably am) wrong!)

BTW, congrats, on being engaged!!

My wife and I recently celebrated our 36th anniversary.

Congratulations to you too!

It was our 3 year anniversary the day after I proposed