Results 1 to 5 of 5

Thread: enter data to a specific row

  1. #1

    enter data to a specific row



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hello all, i have created a userform and i want to have a field where the user has to put the number of the row in which he wants to fill his data

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    Just add another textbox, check it has a value, and use that value.

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Just add another textbox, check it has a value, and use that value.
    thank you for you resond, can you provide me with a code sample that does what you said, because honestly i am new to this

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    If you have created a userform, it must have some controls, this is just another one.

  5. #5
    i understood what you said to create a textbox for the number of the row, but how to code that box to take this number and to copy the data that are entered in fields of the userform to that row
    currently my code is looking for the first empty row, but i want to do it like i said before based on the row number
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Untitled.jpg 
Views:	9 
Size:	94.1 KB 
ID:	3446  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •