+ Reply to Thread
Results 1 to 6 of 6

[UserForm] Column value not changing after pressing "Enter" key in textbox

  1. #1
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    [UserForm] Column value not changing after pressing "Enter" key in textbox

    Please Login or Register  to view this content.
    Column variable:
    • q is column property i.e column number. This is in row 10.

    Userform variables:
    val.: using textbox to enter data into row 11
    question.: displaying column header value in textbox

    Overall scheme: question and answer where data is entered col by col per row.

  2. #2
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Re: [UserForm] Column value not changing after pressing "Enter" key in textbox

    Total columns are correct and is 72 as expected (variable Col). To add to above thread.
    Attached Files Attached Files
    Last edited by immigrated4urjob; 02-02-2022 at 04:36 PM.

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: [UserForm] Column value not changing after pressing "Enter" key in textbox

    see big yellow banner - how to upload your workbook.
    far easier to give advice when seeing full context.
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  4. #4
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Re: [UserForm] Column value not changing after pressing "Enter" key in textbox

    Quote Originally Posted by torachan View Post
    see big yellow banner - how to upload your workbook.
    far easier to give advice when seeing full context.
    Done. Contains userform plus workbook event. See my second post.

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: [UserForm] Column value not changing after pressing "Enter" key in textbox

    Total columns are correct and is 72
    how is this relevant ?
    have I understood your concept correctly - "you want to enter data to each cell individually - (row by row, column by column with the aid of a userform)

  6. #6
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126
    Quote Originally Posted by torachan View Post
    how is this relevant ?
    have I understood your concept correctly - "you want to enter data to each cell individually - (row by row, column by column with the aid of a userform)
    Focusing on looping column by column only

+ 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] Changing how "Enter" works on a Userform
    By rpjwhite in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-10-2017, 04:15 AM
  2. [SOLVED] "Enter" going to next line inside a textbox on a userform
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2016, 04:08 PM
  3. Need CountCellsByColor formula to update automatically without pressing "F2" "Enter"
    By PsychicFish in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-16-2016, 12:40 AM
  4. [SOLVED] Powerpoint Macro for Pressing "Enter" Key after Commas in First Slide in Normal View
    By mlexcelhelpforum in forum PowerPoint Programming
    Replies: 1
    Last Post: 08-02-2012, 04:09 AM
  5. VBA editor auto changes "." to "'#" as you type ... not just after pressing <enter>?
    By Stripey_uk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-04-2011, 08:00 AM
  6. Replies: 5
    Last Post: 02-22-2006, 02:50 PM
  7. [SOLVED] How can I follow a Hyper-link by just pressing "Enter"?
    By Bob in forum Excel General
    Replies: 1
    Last Post: 04-05-2005, 10:06 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