+ Reply to Thread
Results 1 to 4 of 4

TextBox Naming & Value Input

  1. #1
    Forum Contributor
    Join Date
    02-26-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    275

    TextBox Naming & Value Input

    I have userform (frmLine) with six TextBoxes named txtPrice, txtPrice1, txtPrice2 etc.
    The userform has a TextBox (txtLines) which shows a line number.
    The value to be inserted into the last five TextBoxes is based on the first (txtPrice).
    Instead of using the following code:
    Please Login or Register  to view this content.
    I wish to use code similar to the following:
    Please Login or Register  to view this content.
    But this is not working! What modification can I make to get it working”
    Thanks Sandy

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,630

    Re: TextBox Naming & Value Input

    I've been reading your question about 10 times and I still don't have a single clue of what you're trying to achieve.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

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

    Re: TextBox Naming & Value Input

    Perhaps something like

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  4. #4
    Forum Contributor
    Join Date
    02-26-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    275

    Re: TextBox Naming & Value Input

    Bakerman2 I am trying to simplify some coding to enter data, have a look at the attached which shows the beginning of the form (a work in progress).
    I was using Select Case but there were 6 sets of code. With Mikes code there is only one set.

    Mike thanks, with a slight modification it worked.

    Please Login or Register  to view this content.
    Cheers Sandy
    Attached Images Attached Images

+ 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. Copying TextBox input
    By Jon_Strack in forum Excel General
    Replies: 3
    Last Post: 02-10-2014, 05:30 PM
  2. 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
  3. Input Mask for TextBox
    By AndyE in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2012, 06:04 AM
  4. 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
  5. Use checkbox to allow textbox input
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2010, 01:54 AM
  6. Naming labels on Input Form problem
    By PaulC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2007, 05:09 AM
  7. is it possible... (multiple input+naming)
    By rbmcclen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2006, 09:25 AM
  8. Textbox input interpretation
    By Mats Samson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2005, 10:05 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