+ Reply to Thread
Results 1 to 9 of 9

Textbox1 's value Copy to textbox2, textbox3, textbox4, textbox5 Solved by : Sixthsense

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

    Thumbs up Textbox1 's value Copy to textbox2, textbox3, textbox4, textbox5 Solved by : Sixthsense

    Hello Evryone

    In Userform

    I M Using 5 Textbox

    In Textbox1 If I Type Value = 5
    Then
    All other textboxes auto filed by the value of Textbox1
    Result Should be

    textbox2 = 5

    textbox3 = 5

    textbox4 = 5

    textbox5 = 5

    thanx
    Last edited by HaroonSid; 03-25-2014 at 02:58 AM. Reason: solved

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Textbox1 's value Auto Copy To textbox2, textbox3, textbox4, textbox5 : UserForm

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

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

    Re: Textbox1 's value Auto Copy To textbox2, textbox3, textbox4, textbox5 : UserForm

    Sixthsense


    Amazing working very well


    thanx a lot
    haroon2015

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

    Re: Textbox1 's value Auto Copy To textbox2, textbox3, textbox4, textbox5 : UserForm

    Another one question

    same procedure
    If i use Combobox in place of textbox

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Textbox1 's value Auto Copy To textbox2, textbox3, textbox4, textbox5 : UserForm

    Instead of using the word "TextBox" replace it with "ComboBox"

  6. #6
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Textbox1 's value Copy to textbox2, textbox3, textbox4, textbox5 Solved by : Sixthsen

    @sixth

    Dim as byte ?????


    @haroon
    It depends on the style of the combobox.



  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Textbox1 's value Copy to textbox2, textbox3, textbox4, textbox5 Solved by : Sixthsen

    Quote Originally Posted by snb View Post
    @sixth

    Dim as byte ?????
    Because I needed a variable which can hold numbers upto 5.

    Please Login or Register  to view this content.
    I don't know any other variable to hold number upto 5 with lesser memory, since Byte just consume 1 byte for holding 0 to 255.

    Please correct me if I am doing anything wrong

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

    Re: Textbox1 's value Auto Copy To textbox2, textbox3, textbox4, textbox5 : UserForm

    Ok Thanx a lot

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

    Re: Textbox1 's value Auto Copy To textbox2, textbox3, textbox4, textbox5 : UserForm

    With textbox1
    textbox3.Value = .Value
    textbox5.Value = .Value
    textbox9.Value = .Value
    End With

+ 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] Userform Textbox1 = Val(Textbox2.Value) / 2
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2013, 09:37 AM
  2. [SOLVED] Cell Value = TextBox1.Value + TextBox2.Value
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2013, 09:30 AM
  3. [SOLVED] textbox1 * textbox2 = textbox3
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-23-2012, 03:35 PM
  4. Choose 4 Random Numbers if they are not textbox1 or textbox2
    By blitz74 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2012, 02:41 AM
  5. [SOLVED] TextBox1 = TextBox2
    By Anto_BT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2012, 03:34 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