Using user inputed information in the file

[chad portman]

This should be super simple. I am looking for that will open a "Input Box" where the end user has two options one they enter some text and press enter or they click a button to end.

In the case they enter text and press enter-- the text they entered will be inputed into cell A4 on Sheet1 and then run a quick second macro which i already have at the end of that macro it will recall this one to the front another input.

In the case the click the button to end then the "Input Box" will just disappear and nothing else will run and the user will find themselves on Sheet2 with Cell A1 selected.

I knew how to do this at one time but I am drawing a blank. I keep saying "Input Box" because I feel that this is the right command to use but have not used it in so long I am unsure of the how to write what I want.

[judgeh59]

If I'm understanding you correctly try this...

Please Login or Register  to view this content.

[chad portman]

This works for inputting the user data however I need the the ability for 2 options they enter in data that is passed to A4 and then looped back to the input box again or they click something to end the macro.

[judgeh59]

"looped back again"?....so if you entered data it would loop again? OR....you keep getting an input box until you enter something/anything?

[chad portman]

Through the help on this forum and extra google searching I have been able to solve my issue I will post my code to help people understand a little better.

Please Login or Register  to view this content.

As always thanks for all the help.
I do still have one minor issue with the refreshall portion as it is not refreshing the data as intended but the issue I had asked about is fixed so I will open a different thread for that question.