how do i create a pop up box to prompt the user for info?
 

I had created a program a few years ago in Excel, but can't remember how to
do it now. I had a button assigned to a macro, and when the user clicked the
button, a series of pop up boxes prompted the user for information. That
information was then used in the spreadsheet. Now I can't even remember how
to make the pop up boxes. Can anyone help please?

how do i create a pop up box to prompt the user for info?
 

Karyn,

An easy way to create a simple prompt is with the InputBox() function. Put
this into your button macro:

Cells(1,1) = InputBox("Type in something", "My Title")

See help for InputBox() for more options available for the function.

If you want fancier input boxes, you would create User Forms in the Visual
Basic Editor, which gets a bit more complex.

Lee

"Karyn" wrote in message
...
I had created a program a few years ago in Excel, but can't remember how
to
do it now. I had a button assigned to a macro, and when the user clicked
the
button, a series of pop up boxes prompted the user for information. That
information was then used in the spreadsheet. Now I can't even remember
how
to make the pop up boxes. Can anyone help please?

how do i create a pop up box to prompt the user for info?
 

OK, that worked for the pop up box, thank you. But now, it's not putting the
input into that cell....
This wasn't the way I did it before, because I don't know much about
programming, but I do know some. But I'm up for doing it this way if I can
figure out how to work it, I'm stumped.

"Lee S" wrote:

Karyn,

An easy way to create a simple prompt is with the InputBox() function. Put
this into your button macro:

Cells(1,1) = InputBox("Type in something", "My Title")

See help for InputBox() for more options available for the function.

If you want fancier input boxes, you would create User Forms in the Visual
Basic Editor, which gets a bit more complex.

Lee

"Karyn" wrote in message
...
I had created a program a few years ago in Excel, but can't remember how
to
do it now. I had a button assigned to a macro, and when the user clicked
the
button, a series of pop up boxes prompted the user for information. That
information was then used in the spreadsheet. Now I can't even remember
how
to make the pop up boxes. Can anyone help please?

how do i create a pop up box to prompt the user for info?
 

Karyn,

So, you say you get the prompt and you can type in a value, but the value
doesn't go into the cell?

Can you paste the macro code that runs when you click the button?

Lee


"Karyn" wrote in message
...
OK, that worked for the pop up box, thank you. But now, it's not putting
the
input into that cell....
This wasn't the way I did it before, because I don't know much about
programming, but I do know some. But I'm up for doing it this way if I
can
figure out how to work it, I'm stumped.

"Lee S" wrote:

Karyn,

An easy way to create a simple prompt is with the InputBox() function.
Put
this into your button macro:

Cells(1,1) = InputBox("Type in something", "My Title")

See help for InputBox() for more options available for the function.

If you want fancier input boxes, you would create User Forms in the
Visual
Basic Editor, which gets a bit more complex.

Lee

"Karyn" wrote in message
...
I had created a program a few years ago in Excel, but can't remember
how
to
do it now. I had a button assigned to a macro, and when the user
clicked
the
button, a series of pop up boxes prompted the user for information.
That
information was then used in the spreadsheet. Now I can't even
remember
how
to make the pop up boxes. Can anyone help please?

how do i create a pop up box to prompt the user for info?
 

OK, I figured all that out. Now I have a different problem.... I have a
table set up. The dates are all in column A, then in columns F and G, there
are number values. How do I get the sum of the number values for exact dates.

Example: If date = 3/5/05, then add #

Thank you for all your help Lee :)


"Lee" wrote:

Karyn,

So, you say you get the prompt and you can type in a value, but the value
doesn't go into the cell?

Can you paste the macro code that runs when you click the button?

Lee


"Karyn" wrote in message
...
OK, that worked for the pop up box, thank you. But now, it's not putting
the
input into that cell....
This wasn't the way I did it before, because I don't know much about
programming, but I do know some. But I'm up for doing it this way if I
can
figure out how to work it, I'm stumped.

"Lee S" wrote:

Karyn,

An easy way to create a simple prompt is with the InputBox() function.
Put
this into your button macro:

Cells(1,1) = InputBox("Type in something", "My Title")

See help for InputBox() for more options available for the function.

If you want fancier input boxes, you would create User Forms in the
Visual
Basic Editor, which gets a bit more complex.

Lee

"Karyn" wrote in message
...
I had created a program a few years ago in Excel, but can't remember
how
to
do it now. I had a button assigned to a macro, and when the user
clicked
the
button, a series of pop up boxes prompted the user for information.
That
information was then used in the spreadsheet. Now I can't even
remember
how
to make the pop up boxes. Can anyone help please?

how do i create a pop up box to prompt the user for info?
 

Not sure what you are asking, but it sounds like you need the IF function:

=IF(A1="3/5/2005", A1+F1, A1+G1)

When A1 is 3/5/05, then
compute A1+F1
otherwise
compute A1+G1

If the computation returns a number, then format the cell as a date.

Lee


"Karyn" wrote in message
...
OK, I figured all that out. Now I have a different problem.... I have a
table set up. The dates are all in column A, then in columns F and G,
there
are number values. How do I get the sum of the number values for exact
dates.

Example: If date = 3/5/05, then add #

Thank you for all your help Lee :)


"Lee" wrote:

Karyn,

So, you say you get the prompt and you can type in a value, but the
value
doesn't go into the cell?

Can you paste the macro code that runs when you click the button?

Lee


"Karyn" wrote in message
...
OK, that worked for the pop up box, thank you. But now, it's not
putting
the
input into that cell....
This wasn't the way I did it before, because I don't know much about
programming, but I do know some. But I'm up for doing it this way if
I
can
figure out how to work it, I'm stumped.

"Lee S" wrote:

Karyn,

An easy way to create a simple prompt is with the InputBox()
function.
Put
this into your button macro:

Cells(1,1) = InputBox("Type in something", "My Title")

See help for InputBox() for more options available for the function.

If you want fancier input boxes, you would create User Forms in the
Visual
Basic Editor, which gets a bit more complex.

Lee

"Karyn" wrote in message
...
I had created a program a few years ago in Excel, but can't
remember
how
to
do it now. I had a button assigned to a macro, and when the user
clicked
the
button, a series of pop up boxes prompted the user for
information.
That
information was then used in the spreadsheet. Now I can't even
remember
how
to make the pop up boxes. Can anyone help please?

how do i create a pop up box to prompt the user for info?
 

Karyn,

I just noticed a mistake in my expression. Should be:

=IF(A1=DateValue("3/5/2005"), A1+F1, A1+G1)

Lee


"Lee" wrote in message
...
Not sure what you are asking, but it sounds like you need the IF function:

=IF(A1="3/5/2005", A1+F1, A1+G1)

When A1 is 3/5/05, then
compute A1+F1
otherwise
compute A1+G1

If the computation returns a number, then format the cell as a date.

Lee


"Karyn" wrote in message
...
OK, I figured all that out. Now I have a different problem.... I have
a
table set up. The dates are all in column A, then in columns F and G,
there
are number values. How do I get the sum of the number values for exact
dates.

Example: If date = 3/5/05, then add #

Thank you for all your help Lee :)


"Lee" wrote:

Karyn,

So, you say you get the prompt and you can type in a value, but the
value
doesn't go into the cell?

Can you paste the macro code that runs when you click the button?

Lee


"Karyn" wrote in message
...
OK, that worked for the pop up box, thank you. But now, it's not
putting
the
input into that cell....
This wasn't the way I did it before, because I don't know much about
programming, but I do know some. But I'm up for doing it this way
if
I
can
figure out how to work it, I'm stumped.

"Lee S" wrote:

Karyn,

An easy way to create a simple prompt is with the InputBox()
function.
Put
this into your button macro:

Cells(1,1) = InputBox("Type in something", "My Title")

See help for InputBox() for more options available for the
function.

If you want fancier input boxes, you would create User Forms in
the
Visual
Basic Editor, which gets a bit more complex.

Lee

"Karyn" wrote in message
...
I had created a program a few years ago in Excel, but can't
remember
how
to
do it now. I had a button assigned to a macro, and when the
user
clicked
the
button, a series of pop up boxes prompted the user for
information.
That
information was then used in the spreadsheet. Now I can't even
remember
how
to make the pop up boxes. Can anyone help please?

how do i create a pop up box to prompt the user for info?
 

=sumif(A:A,"3/5/05",F:F)

or for both columns

=SUMIF(A:A,"3/5/05",F:F)+SUMIF(A:A,"3/5/05",G:G)

--
Regards,
Tom Ogilvy


"Karyn" wrote in message
...
OK, I figured all that out. Now I have a different problem.... I have a
table set up. The dates are all in column A, then in columns F and G,
there
are number values. How do I get the sum of the number values for exact
dates.

Example: If date = 3/5/05, then add #

Thank you for all your help Lee :)


"Lee" wrote:

Karyn,

So, you say you get the prompt and you can type in a value, but the
value
doesn't go into the cell?

Can you paste the macro code that runs when you click the button?

Lee


"Karyn" wrote in message
...
OK, that worked for the pop up box, thank you. But now, it's not
putting
the
input into that cell....
This wasn't the way I did it before, because I don't know much about
programming, but I do know some. But I'm up for doing it this way if
I
can
figure out how to work it, I'm stumped.

"Lee S" wrote:

Karyn,

An easy way to create a simple prompt is with the InputBox()
function.
Put
this into your button macro:

Cells(1,1) = InputBox("Type in something", "My Title")

See help for InputBox() for more options available for the function.

If you want fancier input boxes, you would create User Forms in the
Visual
Basic Editor, which gets a bit more complex.

Lee

"Karyn" wrote in message
...
I had created a program a few years ago in Excel, but can't
remember
how
to
do it now. I had a button assigned to a macro, and when the user
clicked
the
button, a series of pop up boxes prompted the user for
information.
That
information was then used in the spreadsheet. Now I can't even
remember
how
to make the pop up boxes. Can anyone help please?