+ Reply to Thread
Results 1 to 2 of 2

VBA to populate range with textbox.value form UserForm keyboard input not working

  1. #1
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,027

    VBA to populate range with textbox.value form UserForm keyboard input not working

    Hi All

    I have the below code which populates a cell with information from UserForm30.TextBox1
    UserForm30 is a onscreen keyboard. When I type in a message such as "ABC" , Then TextBox1 gets populated with "ABC"....
    Problem I have is that the actual "ABC" is not filling my cell when the code executes...It fills the cell with a random value i.e. 1 or sometimes a date value....Any Ideas

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,027

    Re: VBA to populate range with textbox.value form UserForm keyboard input not working

    My apologies

    I've being trying to figure it out for an hour and only now realize that I am referencing the incorrect UserForm...My Bad.

+ 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] If Statements in Userform TextBox to populate other textbox
    By Sintek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2016, 06:57 AM
  2. Populate a textbox on Userform with data from a filtered range using VBA
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2014, 04:20 AM
  3. [SOLVED] Input Box a range with keyboard within a Userform
    By bsamuels in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-27-2013, 07:16 AM
  4. input the value of a Combobox and a textbox to a TEXTBOX directly from a userform
    By Gordonhk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 03:25 PM
  5. [SOLVED] populate userform listbox from textbox input
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2013, 10:05 AM
  6. named range to populate default textbox value in User form-initialize
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2012, 09:08 AM
  7. Use textbox input and VLookup to update another textbox on same userform
    By gcoug in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2011, 10:39 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