Input by popup?

[kruzin24]

I'm trying to make a textbox pop up that requests that you put in information, and then that information is put into a specified cell. Data would exist in the cell, and the text put into the textbox would have to overwrite a specific area in that cell. An example is below.

PHOTOS ORDERED: 12 PHOTOS RECEIVED: 8

This would all be in one cell. The words PHOTOS ORDERED: and PHOTOS RECEIVED: would need to remain, and the numbers would need to be overwritten by what numbers are entered in the textbox, and the numbers are not always the same. I don't know where to start with this, or if it can be done. Any assitance would be greatly appreciated. Thank you!

[willakawill]

I'm trying to make a textbox pop up that requests that you put in information, and then that information is put into a specified cell. Data would exist in the cell, and the text put into the textbox would have to overwrite a specific area in that cell. An example is below.

PHOTOS ORDERED: 12 PHOTOS RECEIVED: 8

This would all be in one cell. The words PHOTOS ORDERED: and PHOTOS RECEIVED: would need to remain, and the numbers would need to be overwritten by what numbers are entered in the textbox, and the numbers are not always the same. I don't know where to start with this, or if it can be done. Any assitance would be greatly appreciated. Thank you!

Hi. I will assume that you know how to enter a value into a cell. Here is how to collect the value:

Dim stIn1 As String
Dim stIn2 As String
Dim stCell As String
 
stIn1 = InputBox("Please enter the number of photos ordered", "Photos Ordered")
stIn2 = InputBox("Please enter the number of photos received", "Photos Received")
 
stCell = "PHOTOS ORDERED: " & stIn1 & "         PHOTOS RECEIVED: " & stIn2 

[kruzin24]

I have the popup boxes requesting input now, thank you! Where do I specify the cell to enter the data into? I'm putting the macro on a different sheet other than the one where this macro will be ran. The worksheet that will be edited is called orders.xls. Thanks again!!