I have the following problem and I hope that someone can help me out. Here
goes:

I've got this spreadsheet that around 50 marcos in it. Two main macros that
are assign to word arts. ( word art 30 and word art 32 ). I've got 20 other
Word Art that are 5 digit part numbers. Each assign to it's own macro. When
they select Word Art 30 then each time the employees select one of the Word
Art part numbers it puts the number one in a cell assigned to the macro. Each
time they do this it goes up by one. If they select Word Art 32 then each
time the employee selects one of the Word Art part numbers it puts the pallet
quantity. (Ex. 48 or 30). Each time they do this it goes up by the pallet
quantity. Here is what I'm wanting help with. How can I make it where if they
select Word Art 30 it brings up a window where they can put in the quantity
that it is instead of hitting the button over and over? I'll need it to be
able to write to the same cells as before.