Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to get Excel to correctly display imported UTF8-encoded data ? | Excel Worksheet Functions | |||
post data to create a chart | Excel Discussion (Misc queries) | |||
How do I create a dialog box to pop up when logging out of a docum | Excel Discussion (Misc queries) | |||
Create a dialog box | Excel Worksheet Functions | |||
Create Startup Dialog | Excel Discussion (Misc queries) |