+ Reply to Thread
Results 1 to 2 of 2

i want to have a macro code change based on input from a textbox in a form

  1. #1
    Forum Contributor
    Join Date
    01-27-2015
    Location
    New hampshire
    MS-Off Ver
    excel 2013
    Posts
    143

    i want to have a macro code change based on input from a textbox in a form

    so I have this code and I want the "100" that's show in red to change based on input from a textbox in a form..

    my form is called "qtyform" the textbox is "qtybox" and the form also has a "enter" button called "enterbutton"

    thank you!!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    01-27-2015
    Location
    Queanbeyan, Australia
    MS-Off Ver
    2010
    Posts
    5

    Re: i want to have a macro code change based on input from a textbox in a form

    I am assuming this macro is called when the enterbutton is pressed.

    If this is the case try changing it to

    Please Login or Register  to view this content.

+ 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] user form to input data according to text in textbox and listbox
    By a.hudrea in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 04:27 AM
  2. change textbox color on subform based on condition on another form
    By rlsublime in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2014, 10:04 PM
  3. Code to format number input in textbox controls (based on tag) in userform
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-05-2010, 01:09 PM
  4. User form textbox message for input error
    By microsmith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2007, 02:50 PM
  5. Userform-Change textbox color and font based on input in other tex
    By Neal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-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