input box, row locate

[willsnake]

Hi again,

I am here again seeking help...

What I am trying to accomplish is that, I wish to show an input box where I will input text or number, then a macro will locate the range and identify the row number, then there will be a code for that certain row. Then it will loop until there is no more text or number to locate...

Thnx in advance...

 

[BrianJN1]

Suppose A1 is your input cell, and then a CommandButton is placed beside it, would that work for you?
Um? Do you somehow need another form of prompt to activate such a thought?

 

[willsnake]

an image in my excel will be assigned by a macro that will open an inputbox, then in that inputbox, I will input the data that need locating.

 

[BrianJN1]

an image in my excel will be assigned by a macro .......

Please clarify what you mean by "an image". How is that supposed to appear? Will you want to locate a macro button somewhere on your page to call the macro that gives the input box, AND then continues with your work?

If I seem to be too analytical then your opening comment was not sufficiently clear to me.

 

[willsnake]

an image or a picture assigned or linked to a macro when clicked. it will become like a button that will activate a macro which will open a inputbox.

Application.InputBox("Select the cells in Project Data to process", Type:=1+2)

above will be one of the code that opens an inputbox, I will enter a text or a number, then the macro will find the cell containing that text or number and memorize the ROW number. Then I will run a code after I get the row number, no need to display the row number.

 

[BrianJN1]

My apologies, but I am still lost about that "Image".

What I am trying to accomplish is that, I wish to show an input box where ...

What I am initially trying to establish is THAT image. Is already part of the worksheet or is it to be triggered somehow to ask for your information?
If it is NOT on the sheet then you have to seek a macro. That being so I did offer an input cell and a button to begin the transaction.

 

[willsnake]

Sorry for the confusion... I may have been too excited to post my question here...

In my Excel, there will be a picture or image or a shape. Such image is in the worksheet, When I clicked it, it will open the input box.

 

[BrianJN1]

Sorry for the confusion... I may have been too excited to post my question here...

In my Excel, there will be a picture or image or a shape. Such image is in the worksheet, When I clicked it, it will open the input box.

Ok. I think you may need a visual explanation such as where the image is located, a sample of data and what the input box might be seeking. For instance, you say "row". Is the data sought in Column A only or elsewhere?

 

[willsnake]

the data to be sought will be at another sheet in column C...

 

[BrianJN1]

Ok? The task then is, one clicks on the image in Col A &/or Col B.
A macro is activated which presents an input dialog box.
After entry the macro seeks the row in Col C which holds that data.
You don't really want to see that ROW No because the current macro will be calling another macro to which that ROW No will be transferred? Right?

If that is the case I think we can get there. By the way "Application.InputBox("Select the cells in Project Data to process", Type:=1+2)" creates an error, your second quote should come after the "2".