Input box question

[Janno]

Hi all,

If I use this method for example to return a value into a cell

Please Login or Register  to view this content.

How can I apply this to say cells A1 to A30, if I double click on say A15 enter value through input box it only puts the value in A15 or whichever cell I click in this range.

Hopefully makes sense
Many thanks.

[Paul]

If I'm reading your question correctly, try:

Please Login or Register  to view this content.

[Janno]

Hi Paul

That works exactly as I was hoping to achieve
Many thanks for prompt reply

[Paul]

Glad to assist.

Thanks for the feedback/rep.