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.

There is actually more than one way to do this type of input...

If you just want a basic user input (textbox), then take a look at the
following website.

http://www.ozgrid.com/VBA/inputbox.htm

If you are wanting something more specific... like a calculator type of
input, you will have to build a special user form for that type of input.

Either way, I would recommend running some basic validation on whatever was
input to insure the rest of your code runs properly.

Let me know if you need some specific help.

Mark Ivey


"MWhaley" wrote in message
...
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.

Thanks Mark this worked great, and I really got a lot of good stuff from the
web page.

"Mark Ivey" wrote:

There is actually more than one way to do this type of input...

If you just want a basic user input (textbox), then take a look at the
following website.

http://www.ozgrid.com/VBA/inputbox.htm

If you are wanting something more specific... like a calculator type of
input, you will have to build a special user form for that type of input.

Either way, I would recommend running some basic validation on whatever was
input to insure the rest of your code runs properly.

Let me know if you need some specific help.

Mark Ivey


"MWhaley" wrote in message
...
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.

Glad to help out...

Mark Ivey

"MWhaley" wrote in message
...
Thanks Mark this worked great, and I really got a lot of good stuff from
the
web page.

"Mark Ivey" wrote:

There is actually more than one way to do this type of input...

If you just want a basic user input (textbox), then take a look at the
following website.

http://www.ozgrid.com/VBA/inputbox.htm

If you are wanting something more specific... like a calculator type of
input, you will have to build a special user form for that type of input.

Either way, I would recommend running some basic validation on whatever
was
input to insure the rest of your code runs properly.

Let me know if you need some specific help.

Mark Ivey


"MWhaley" wrote in message
...
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.