+ Reply to Thread
Results 1 to 9 of 9

Can't overide quantities???

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Can't overide quantities???

    Hi,

    I have the following code that populates the relevant TextBoxes with quantities, which remain the same 98% of the time. However, I received an enquiry whereby I needed to change the quantities but I couldn't.
    Dose anyone one know of a solution I could add to this code to override the quantities if need be?



    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Can't overide quantities???

    what does 'I couldn't' mean?
    Do you want to change the values in the sub? Or you want to be able to edit the values once the user form is opened and was not able to...?
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Can't overide quantities???

    Load (not 'Show') the userform and and then directly update each control

    Please Login or Register  to view this content.
    If you really have 69+ unnamed controls (other than the default 'Textbox69') I would hate to have to review/edit your code. Do you not name controls according to the data they receive? Makes it a hell of a lot easier to read code and you won;t have to comment every line to remind yourself what the control refers to...

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,006

    Re: Can't overide quantities???

    If you mean the user can't manually override the values put in by the code, then perhaps the texboxes' .Locked property is set to true?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  5. #5
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Can't overide quantities???

    Quote Originally Posted by Arkadi View Post
    If you mean the user can't manually override the values put in by the code, then perhaps the texboxes' .Locked property is set to true?
    Or .Enabled is set to False

  6. #6
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,006

    Re: Can't overide quantities???

    Quote Originally Posted by buran View Post
    Or .Enabled is set to False
    Good point

  7. #7
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Can't overide quantities???

    Also, sometimes in my projects, I implement a sort of safety feature - textbox is locked or disabled to prevent user from edit the value, but double click by the user 'unlocks" it and allows to edit the value. I suspect there might be something similar here - i.e. otherwise why not use labels, instead of textbox?

  8. #8
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't overide quantities???

    Thanks all, I will pick this up in the morning,thanks very much for your assistance

  9. #9
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't overide quantities???

    Thanks very much all.

+ 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] How can I overide my macro???????
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-11-2016, 10:59 AM
  2. How to overide a formula
    By shanni11 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-10-2016, 03:12 AM
  3. VBA overide fromula
    By OmarFahmy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2014, 05:09 AM
  4. [SOLVED] Manual Overide
    By Mel B in forum Excel General
    Replies: 4
    Last Post: 02-10-2013, 09:27 PM
  5. Overide Workbook Script
    By georgeeasten in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2010, 06:25 AM
  6. overide conditional formatting with VBA
    By Code Flunkie in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-30-2010, 10:41 AM
  7. Overide the data in list box?
    By ballack in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2007, 03:27 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