Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get Excel to correctly display imported UTF8-encoded data ? Elizabeth Excel Worksheet Functions 0 April 24th 08 03:01 PM
post data to create a chart Dave Newman Excel Discussion (Misc queries) 1 March 28th 07 02:16 PM
How do I create a dialog box to pop up when logging out of a docum Perki Excel Discussion (Misc queries) 0 September 5th 06 11:44 PM
Create a dialog box Raza Excel Worksheet Functions 3 December 2nd 05 06:34 PM
Create Startup Dialog coal_miner Excel Discussion (Misc queries) 2 June 8th 05 07:25 PM


All times are GMT +1. The time now is 08:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"