+ Reply to Thread
Results 1 to 4 of 4

Data entered from Userform Textbox shoud be in sheet2 z5

  1. #1
    Forum Contributor
    Join Date
    06-30-2018
    Location
    Azerbaijan
    MS-Off Ver
    Excel 2016
    Posts
    145

    Data entered from Userform Textbox shoud be in sheet2 z5

    Hey dear community,

    I have textbox in userform , i want numbers entered to textbox to be in sheet2 z5 cell can anybody help me please?

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Data entered from Userform Textbox shoud be in sheet2 z5

    Assuming you have a CommandButton on UserForm named CommandButton1 and TextBox named TextBox1, place the following code on the UserForm Module.

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    06-30-2018
    Location
    Azerbaijan
    MS-Off Ver
    Excel 2016
    Posts
    145

    Re: Data entered from Userform Textbox shoud be in sheet2 z5

    Quote Originally Posted by sktneer View Post
    Assuming you have a CommandButton on UserForm named CommandButton1 and TextBox named TextBox1, place the following code on the UserForm Module.

    Please Login or Register  to view this content.
    It works thank you very much
    Last edited by Akbarov; 07-01-2018 at 06:01 AM.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Data entered from Userform Textbox shoud be in sheet2 z5

    You're welcome!
    Thanks for the rep.

    If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

+ 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. Run code when values are entered in userform textbox?
    By c.davidson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2016, 06:05 AM
  2. [SOLVED] Updating text in shape using data entered in a textbox in userform.
    By Awni in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-23-2016, 06:48 AM
  3. Restrict the value entered into a textbox on a userform
    By D.Lovell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2015, 05:30 PM
  4. [SOLVED] Search column for entered value and return results to textbox in userform
    By MIFF3436 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 06:35 AM
  5. Copy Data Entered in Sheet1 fix row to sheet2 always on next row
    By muneshmeena in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2013, 09:17 AM
  6. [SOLVED] Saving textbox data from a userform to Sheet2 cells...
    By goldbeje in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2012, 04:32 PM
  7. [SOLVED] show message box when a duplicate entry is entered into a userform textbox
    By reggie1000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2012, 05:53 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