Get the returned value of an InputBox into UserForm text box

[julhs]

I hope this is not too much of a simplistic question!
From a USER FORM I trigger an InputBox to select a range.
Question is: HOW do I return the InputBox value/result back to a TEXTBOX on the UserForm.
So far!! I’ve got to returning the InputBox value/result to a cell on the sheet, so when the UserForm is “Initialised” a text box on the UserForm that displays the value of that given cell.

BUT I want to try and find a way to short circuit that, so that I can get the InputBox value/result (that is returned) directly into a text box on the ACTIVE UserForm.
The InputBox routine is in the main code of the UserForm (so called from a cmd button on the UserForm)

So in my overly simplistic logic; I should be able to return the InputBox value directly back to the ACTIVE UserForm text box!!!!!!
I’m NOT about asking for a solution code, rather the method to return InPutBox to text box on the UserForm, otherwise before you know it I’ll be back asking for further assistance to modify things!!!
The learning curve is the key aspect; BUT when you forget 50% of what you MIGHT have learnt; it make life difficult!!!

 

[julhs]

PS; if it makes a difference we are dealing with the Active UserForm on the Active WorkSheet at the time

 

[dmt32]

Hi,
instead of an inputbox, have a look & see if using the the RefEdit control on your form would work for you

There is a good article here that gives guidance to the control :Using RefEdit Controls in Excel Dialogs - Peltier Tech

Dave

 

[julhs]

Thank you.
Had hit upon “RefEdit” in searches, but attempting to apply it didn’t seem to get INTO the UserForm txtbox the outcome of the InputBox returned value.
Now, in no way does that mean I can’t use “RefEdit”, MOST likely is I haven’t structured the code correctly.
I WILL test again the use of “RefEdit”, but for now is there anything else I may need to look at?

Just notice slight difference in your remark to “RefEdit” compared to how/where I’ve tested its use, so the suggestion is that I need to look again at “RefEdit”??
I'll have to change my code and come back to you.

 

[julhs]

Had a look at that link.
The line below in "ReFEdit Irregularities" section
“RefEdits must not be used on modeless forms. RefEdits on modeless forms will result in bizarre Excel crashes.”

Utlimatly means RefEdits is not going to be an option for me as my UserForm is Modeless.
So for now I’ve left off my initial idea and currently testing a different approach.
Thanks for the link though