+ Reply to Thread
Results 1 to 5 of 5

textbox in a user form

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2016
    Posts
    270

    textbox in a user form

    I am just creating a user form (my very first user form). it just a text box and a command button to save the data entered in the text box to a cell
    in a particulary sheet.

    The issue is whenever i want to enter a text in the box in the run mode, it going back to designer mode .

    unable to understand the issue. i have checked the properties of the text box
    Enabled= true / i have tried false also
    locked= false
    visible= true

    What can be the problem. suggestions please

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: textbox in a user form

    What code is in the userform's code module.
    How are you invoking the userform? F5 from the VB Editor or calling it via macro from the worksheet?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2016
    Posts
    270

    Re: textbox in a user form

    invoking userform through F5.

    It doesnt have any code except the text box where the value is entered, submit button is clicked it saves the value on the sheet
    and exit button unload the user form . beyond this there is nothing.

    The issue is the focus is not going into text box either using tab, or by mouse clicking into the empty text box.

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: textbox in a user form

    The .TabStop property of the TextBox set to True?
    What is the code that is in the userform's code module?

  5. #5
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2016
    Posts
    270

    Re: textbox in a user form

    Yes it is . and it just started working now. i also found enable in false mode while it should be true.

    i have created other text boxes along with the old one I think the problem lies in the property settings for the text box
    which seem to be ok now.

    There is no code except unload me in exit button. and text value assigned to a cell on the sheet on the submit button.

    Anyways thanx a lot mikerickson for your help.

+ 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. vba excel user form restrict input on user textbox
    By samz93 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2013, 04:38 PM
  2. empty textbox in user form
    By rajeev.raj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2010, 08:25 AM
  3. User Form TextBox Events
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2010, 02:07 PM
  4. [SOLVED] textbox on user form
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2005, 12:45 PM
  5. User Form in VB = TextBox
    By Kel in forum Excel General
    Replies: 1
    Last Post: 08-10-2005, 08:05 PM

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