ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to create dialog box that will post to worksheet encoded data? (https://www.excelbanter.com/excel-discussion-misc-queries/247155-how-create-dialog-box-will-post-worksheet-encoded-data.html)

joromajr

How to create dialog box that will post to worksheet encoded data?
 
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?
--
joromajr

JLatham

How to create dialog box that will post to worksheet encoded data?
 
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.


"joromajr" wrote:

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?
--
joromajr



All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com