How to create dialog box that will post to worksheet encoded data?

J

joromajr

I'd like to create a dialog box or text box that will post ot worksheet
informations like Client's name, address, and so on to a worksheet?
 
J

JLatham

This takes VBA code (macros) to accomplish. There are two ways to do it;

one way would be with a series if InputBox$() statements that get the
information one item at a time and put it on a worksheet;

the second way, and probably much better, would be to create a UserForm to
gather all of the related information at one time and place it on the
worksheet.

I'd be willing to help you get started with this if you'd like. It's a
little more than can easily be covered here in a posting or two, so if you'd
like me to help, just get in touch through email to (remove spaces)
HelpFrom @ JLatham Site.com
and remind me of what you would like me to help with. A link to your
initial posting would be helpful also.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top