Results 1 to 5 of 5

Calling multiple instances of a single userform

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2014
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    41

    Question Calling multiple instances of a single userform

    Greetings All,

    As a VBA novice I have played around and have successfully managed to select a date from a PopUpCalendar (MonthView Control) on the form and have the date placed in a textbox (txtBirthDate) located to the left of a command button

    My question is this - I would like to reuse the same PopUpCalendar for other textboxes (there are two on this form) and have the result returned to the left of each respective textbox.

    As you can see by the current form in the attached file, selecting the second calendar only serves to update the first textbox. I am not sure how to have the PopUpCalendar differentiate between textboxes. I would rather not create a new useform with a MonthView control to the side of each textbox as I believe this would be inefficient.

    Any assistance is appreciated and thank you for your time.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copying single instances of multiple names
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-01-2013, 04:56 AM
  2. Multiple Instances to Single Instance
    By jcholla in forum Excel General
    Replies: 2
    Last Post: 11-16-2011, 04:22 PM
  3. Multiple instances of the same userform.
    By mikerickson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2007, 09:56 PM
  4. Find Multiple instances of Single Criterion in Row & Return To a Single Col
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-09-2006, 10:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1