InputBox Bypass Range Confirmation

[publius190]

Hi everyone,

I am searching for a way to get user input that doesnt require the user to confirm what they select.

Currently my program asks the user to select a cell and executes code based on their result.
I have noticed that with inputBox you have to select a cell or range and then confirm it before the code executes. Is there some way to bypass the confirmation and just have the first mousepress pass the value of that cell?

If it's not possible with InputBox I'm open to other suggestions.

Thanks

[Arkadi]

What do you mean by confirm? That they have to click an OK button?
Can you share your workbook or current code?

[mehmetcik]

Andy Pope published something that we might be able to sadapt.

http://www.ozgrid.com/forum/showthread.php?t=56197

[mehmetcik]

Success!

Try this.

Please let me know if you get anywhere with this.

It could be useful

It runs on selection change and right click.

It will meet your requirements.

[publius190]

I guess my question wasn't clear enough. I didn't include code because it's not really relevent.

Arkadi, Yes I would like to find a way to skip the user hitting "OK" and just automatically use whatever range they click. It seems like a simple thing, but it would really help my program run more smoothly.


Some Thoughts:
Thinking about the way the inputbox works it seems unlikely that there is anything built in (because the function can return many types). I stumbled on an article which showed a way to check for mouse input by writing a function in the worksheet, but I am struggling on how send that data to a running program which exists in a class module.

[Arkadi]

What about using the textbox.exit event?

[mehmetcik]

Did you try my userform?

If it is open and you click on a cell then the textbox picks up the cell address and the textbox change event is triggered.