+ Reply to Thread
Results 1 to 3 of 3

ComboBox Selection With Specific Post Command

  1. #1
    Registered User
    Join Date
    04-11-2016
    Location
    Ghana
    MS-Off Ver
    2007
    Posts
    32

    ComboBox Selection With Specific Post Command

    i have attached to this post my Excel workbook to record processed payment vouchers. I have a UserForm1 with a combobox with the label "Currency Type". Upon selection it displays the currency symbol on a Label which subsequently allows the user to type in the amount. On the sheet named "ProceesedPV" are last but three columns bearing the headings of the various currencies. What i want the userform to do is that when a user selects a particular currency from the combobox2 and enters the amount, the entered amount in the textbox16 should be sent to the particular column based on the combobox2 selection. Can this be done or will be glad to receive other alternative as to how this can be done. I just want to avoid the creation of three(3) separate textboxes to do this function. any help? Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: ComboBox Selection With Specific Post Command

    In the Sub CommandButton2_Click()
    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,282

    Re: ComboBox Selection With Specific Post Command

    Please Login or Register  to view this content.
    Please give all those textboxes, comboboxes and labels more descriptive names to make your code more (ah) readable...
    Last edited by protonLeah; 10-06-2018 at 02:47 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I populate a specific range in one ComboBox based of selection of another ComboBox?
    By gmr4evr1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2015, 04:32 PM
  2. [SOLVED] Using Command Button to Open Worksheet Based on ComboBox Selection
    By laura_jean in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-10-2014, 09:23 AM
  3. Playing specific WAV files with a command button using a combobox value
    By Marc De Vlam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2013, 01:22 PM
  4. [SOLVED] Command button to reset ComboBox selection
    By Darrenh1238 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 06:14 AM
  5. Go to Specific Range through ComboBox Item Selection
    By loknath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2012, 06:47 AM
  6. Replies: 2
    Last Post: 01-03-2012, 11:23 AM
  7. based on selection in a combobox I need the corespoding value in a specific cell
    By iscar_marius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2009, 02:49 AM

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