+ Reply to Thread
Results 1 to 4 of 4

USERFORM help

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    U.S
    MS-Off Ver
    Excel 2003
    Posts
    7

    USERFORM help

    I am attempting to create a userform with the following labels
    Date: ( I have a TextBox for the Date and the Quote)
    Quote:

    To: ( I would like to create a dropdown list to pick an object from. for example a customer list)

    I am able to create the Userform with the Labels and I am able to program the "Clear", and "Cancel" command buttons. Currently I have my end result attached. I am having trouble programming the "OK" command button to export the data next to the empty cells. For example exporting the "Date" info so it can populate the cell "B5" in sheet 1.

    Can anyone help push me in the right direction?
    Any help would be appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

    Re: USERFORM help

    Hi,

    you have your code in strange procedure OK_Click ;-)

    Try to put this method into other procedure
    Please Login or Register  to view this content.
    and it will work fine...

    Best Regards

  3. #3
    Registered User
    Join Date
    06-09-2011
    Location
    U.S
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: USERFORM help

    Thanks for your help. It works great!!

  4. #4
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

    Re: USERFORM help

    mark this thread as Solved

    Best Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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