Search:

Type: Posts; User: kbishop94; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: help with 'advance to next record' code for button on userform

    Great information, thank you Dave.

    And the code worked great. No changes necessary at all.... right out of the box & worked on the fisrt try!
  2. help with 'advance to next record' code for button on userform

    I have 2 userforms in my workbook. One is for entering a record, and the other is for editing/viewing a previously entered record.
    I would like to add an additional commandbutton to the editing...
  3. Re: compile error- "user-defined type not defined"

    I did manage to open the workbook on a 64bit machine (one of our other plants have a couple newer workstations that are 64 bit ) using the 64bit version of Microsoft Office and it did work fine...
  4. Re: compile error- "user-defined type not defined"

    Thank you for the reply: Microsoft Office 2010, Version 14.0.7232.5000(32-bit)

    Throughout my company there are a few newer version (64bit) machines and I tried the code out on it too and it also...
  5. compile error- "user-defined type not defined"

    I was sent a workbook from one of our suppliers and asked to complete it (its a questionnaire.) Whenever someone tries to choose a selction from one of the drop-down boxes on the worksheet (not in a...
  6. Re: checkbox to check automatically IF any of other checkboxes are checked

    That did the trick. THanks so much
  7. Re: checkbox to check automatically IF any of other checkboxes are checked

    Hello DanteAmor, thank you for the code. However, I am running into this error:
    I tried placing the 'select ctlLoop' part up on the same line as the 'Then', but I get the sasame error... Do I not...
  8. Re: checkbox to check automatically IF any of other checkboxes are checked

    What if I have checkboxes on the form that I want excluded from the other grouped checkboxes? Is there a easy way to go about this? (there are only 2, and if that cant easily be done, I can use...
  9. VBA script for capturing all names of objects on a userform for the purpose having the capability to rename them

    WHAT I AM WANTING TO DO:

    I have a userform that I use for entry purposes.

    I have a second form that I use for editing the previous entries. The second form (editing form) largely mirrors the...
  10. Re: taking text in a cell and putting it into a comment for that cell WHEN YOU CLICK ON THE CELL...

    Thank you, that did the trick! https://www.mrexcel.com/forum/images/icons/icon14.png



    and... , I dont want to bore you.. but I do have a reason. ; )

    The workbook for this code lists...
  11. Re: checkbox to check automatically IF any of other checkboxes are checked

    Well thank you for helping me learn... which you have alot within this thread and my checkbox request! https://www.mrexcel.com/forum/images/icons/icon14.png



    Sorry for the delay in my...
  12. Re: taking text in a cell and putting it into a comment for that cell WHEN YOU CLICK ON THE CELL...

    Thank you for the help and for the code.

    It semi-works..... ;)

    Its 'cutting' the entire text (not copying) within the cell and then it places that into the comment. So, its doing exactly what...
  13. taking text in a cell and putting it into a comment for that cell WHEN YOU CLICK ON THE CELL...

    the last part in the title of my request here ("WHEN YOU CLICK ON A CELL") is what I am really after...
    CURRENTLY I have code in my worksheet that when a commandbutton is clicked, it takes all the...
  14. Re: checkbox to check automatically IF any of other checkboxes are checked

    some FWIW just in case you're curious as to what and why i am (trying) to do here... here is why:
    I have code from my other main spreadsheet I use at my work here that I realized will work...
  15. Re: checkbox to check automatically IF any of other checkboxes are checked

    Last question... (I swear this time :pray:)

    I just ran into something else that I didnt think about... First of all... if.. this is going to be too difficult or just going to be a giant PITA,...
  16. Re: checkbox to check automatically IF any of other checkboxes are checked

    :banghead:

    Sorry.

    I see now what you mean. That totally fixed it.
  17. Re: checkbox to check automatically IF any of other checkboxes are checked

    Here is the code that I am running (everything runs as intended (without any errors or hiccups I mean) except that it ignores case 2, 3 and 4 (whatever case I put in the #1 position it will work...
  18. Re: checkbox to check automatically IF any of other checkboxes are checked

    I did just find one minor issue with the code... it only works with whatever Case number comes first in the code below...so the way it is listed below, its only looking at 'Case 1' grouping of...
  19. Re: checkbox to check automatically IF any of other checkboxes are checked

    DanteAmor:
    Thank you(!) that worked beautifully on the very first try. https://www.mrexcel.com/forum/images/icons/icon14.png

    And a fine 'tip of the cap' to you, kind sir!! :laugh:
  20. Re: checkbox to check automatically IF any of other checkboxes are checked

    Here a more complete screenshot of my userform. You can see the 4 different groups of checkboxes I have. (but NOT grouped using VBA... just "grouped" for the specific area that they all relate to.)...
  21. Re: checkbox to check automatically IF any of other checkboxes are checked

    Thank you, Tetra. THis works as well... please see my additional question regarding if I would be better off grouping these (and 3 other similar groups of checkboxes on my userform) :confused:
  22. Re: checkbox to check automatically IF any of other checkboxes are checked

    Thank you DanteAmor, this worked just fine.

    Not sure if I should start another thread for this or just post it here...(if I am wrong a mod can lock this :warning: )

    I would like to limit the...
  23. checkbox to check automatically IF any of other checkboxes are checked

    So here is a brief snippet of my userform i have to use as an example:
    http://i68.tinypic.com/o0arfn.jpg

    the top right-hand box (where it says "miscellaneous incidents") has a transparent label...
  24. copy string from a cell into a comment... but... copy it whenever the cell is clicked

    The way my current code works is like this:

    I have a command button that when clicked, it copies all the text inside all the cells within a certain range, and inserts them into comments for those...
  25. Re: why would a 64bit windows still trip over this code(when all the code that wasn't compliant has been removed?)

    Thank you. Both suggestions worked https://www.mrexcel.com/forum/images/icons/icon14.png ultimately though unchecking the reference box was obviously the better solution as there were still TONS of...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4