+ Reply to Thread
Results 1 to 10 of 10

According to combobox1.value change textbox value

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,081

    According to combobox1.value change textbox value

    hello,
    i want to change textbox.value according to combobox1.value

    i m trying to do like :

    Please Login or Register  to view this content.
    i mean if combobox1.value = "ANEES G"
    and i type in textbox25.value = 125

    then auto plus the 0.50 value in textbox25.value

    result should be in textbox25 = 125.50


    thanx
    Last edited by HaroonSid; 06-18-2014 at 05:30 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: According to combobox1.value change textbox value

    Are you typing in 125 after the change to the combo?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,081

    Re: According to combobox1.value change textbox value

    yes nathansav

    i change first combobox1.value then i type in textbox25.value = 125

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: According to combobox1.value change textbox value

    Ok, and is the code triggered off the change on the combo or textbox?

  5. #5
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,081

    Re: According to combobox1.value change textbox value

    Change on the combo

  6. #6
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: According to combobox1.value change textbox value

    There's your answer it needs to be on the textbox change to or just.

  7. #7
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,081

    Re: According to combobox1.value change textbox value

    look

    i run userform then

    i select combobox1.value = ANEES G
    now i type 125 in textbox25
    now i want
    after typing 125 i want to get the result in textbox25 = 125.50

  8. #8
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: According to combobox1.value change textbox value

    Yes, so LOOK, you are changing the text box after your combo, but you have your code in teh combo_change event

    so you need Textbox25_Change()

    your code...

    Think, how does the combo change event work on the text box change. If you did the text box to be 125 first, then changed the combo it would work.

  9. #9
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,081

    Re: According to combobox1.value change textbox value

    ok
    give me proper code

  10. #10
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,081

    Re: According to combobox1.value change textbox value

    Thanx nathansav

    this code is working perfect, but i m filling first textbox then combobox,

    but its good if i fill combobx then fill textbox,

    Please Login or Register  to view this content.

+ 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. UserFrom Match, Find and Edit data : ComboBox1 Change range
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 09:06 AM
  2. [SOLVED] TextBox Value Change According Combobox1 Solved by : jaslake
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-02-2014, 10:00 AM
  3. combobox2 change --> combobox1 change
    By mabulco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2013, 10:38 AM
  4. [SOLVED] If ComboBox1 = Text Then Show List name in TextBox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2013, 03:36 PM
  5. Replies: 3
    Last Post: 05-07-2012, 09:46 PM

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