LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Helpful userform tricky to program

As an added benefit to my users, I thought I'd be a nice guy and add in a
City, State and Zip browser, where the user picks the state, then the city,
then the zip out of comboboxes. Then, once found, can add any piece
separately to the section of the program they are in.

The problem is there are several places I want to use this, so there are
several places in which the user could be sending the information found to.

For instance I have a "License" userform in which the user enters all their
personal/company information (or in some cases, the sales manager enters
their clients company information so they can complete orders for said
company). In another example, I have a customer information worksheet in
which the user would enter the delivery address of his clients.

So, in short, I need to be able to pass my City/State/Zip userform three
variables that dictate where the user wants to send the City, the State and
the Zip once they've found them. It has to be able to send to either cells
or text fields on a userform.

Any suggestions are greatly appreciated!
Thank you
CB Hamlyn


 
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
Why is AutoFill helpful Delba Jones Excel Discussion (Misc queries) 2 February 17th 09 07:08 AM
Helpful New Functions: ALL and ANY Atreides Excel Worksheet Functions 6 September 25th 06 06:38 PM
tab in userform locks program bruce forster Excel Programming 6 April 30th 04 11:01 PM
Can I program a userform via spreadsheet? Phillips Excel Programming 2 November 27th 03 04:11 AM
Repost: Looking for info on how to program a userform to use filters Tom Ogilvy Excel Programming 9 August 7th 03 03:41 AM


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

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

About Us

"It's about Microsoft Excel"