Input Box Macro

[boldcode]

Hi,

I want to create a Macro with an input box that tells a user to "Enter an S Name". The name entered will always go in cell A1. The input box will have an OK and a Cancel button.

That's it!

Thank You

[Break_Point]

Hi,

Please Login or Register  to view this content.

Think this should do it.

[AlphaFrog]

Please Login or Register  to view this content.

[boldcode]

Break_Point,

Thank you!

- BC

[boldcode]

AlphaFrog,

Thank you, that did it!

- BC

[boldcode]

AlphaFrog,

What code would I use if the user hits the cancel button, then it would exit the sub procedure.

[AlphaFrog]

Please Login or Register  to view this content.

[boldcode]

AlphaFrog,

Thanks, that works just the way I want it to.

- BC