Enter text/value from dialog box

[govanalyst]

Is there a way to create a dialog box that prompts you to enter a text/value and then by clicking "ok" have that text/value be entered into the next available row on a sheet?

[mikerickson]

Try this

Please Login or Register  to view this content.

[mikerickson]

duplicate of above post

[stnkynts]

Another idea. Some assumptions were made:

Please Login or Register  to view this content.

[mikerickson]

@stnkynts,
The test for myInput being vbNullString is unneeded since both branches of that test have the same result.