+ Reply to Thread
Results 1 to 2 of 2

Text box value based on two other text boxes

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Text box value based on two other text boxes

    Hi could anyone help please?

    im trying to calculate a text box based on two different text boxes, so if my combox = eur then it shows the euro rate, if it equals usd it shows the usd rate, this works fine, if i put a figure say 20 in text box 2 once i have clicked through the form, the purchase price divides 20 by the rate, but if i change the combo box to usd it wont change the purchase price?.....

    What am i doing wrong here?


    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Thanks Dan
    Last edited by shiftyspina; 12-09-2013 at 10:35 AM. Reason: wrong code

  2. #2
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Text box value based on two other text boxes

    Sussed it i changed purchaseprice_enter() to change() and also added a few change() and afterupdate() to the textbox2 and fxrate and it seems to work fine now

+ 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] Code to populate text boxes based on value of ComboBox1
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2013, 01:46 AM
  2. [SOLVED] Text Boxes: Insert/Text Box vs. Developer Text Boxes
    By snapfade in forum Excel General
    Replies: 5
    Last Post: 10-09-2012, 01:45 AM
  3. Populate Text Boxes based on Combo Box Selection
    By Sasha28 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2012, 06:32 PM
  4. Replies: 2
    Last Post: 02-19-2010, 03:55 PM
  5. [SOLVED] generating text box value based on equation from other boxes
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2006, 11:34 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