Can a macro with input boxes do this?
Posted by Tim Johnson on December 14, 2001 7:40 PM
I need help with a macro and some inputboxes. Below is a short example of what I am trying to accomplish:
accounting expense 26.00
legal expense 26.19
Is there a way to create a macro that has input boxes for me to type in the expense accounts (1 to 1 million or so) and have a button on the input box to tell the macro that I am through entering expenses? Then I want the macro to sort the expenses alphabetically and enter them in a cell that I choose, probably through another input box. I also want it to create an expense code, also in a cell that I choose through yet another input box, and fill the series down. The trick to that is that the expense codes must start with the same # (and I also would like to be able to tell it which # to start with by another input box) and the .## must be 2 digits and be evenly spaced between 01 and 78.
If anyone can help me (I know this is a huge pain in the butt) but I WOULD REALLY APPRECIATE IT!!!!!!!!!! It would really help me a lot for my job..
THANK YOU SO MUCH IN ADVANCE!!!!!!!!!!!!!!!!