Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    26
    Views
    839

    Hi RG Where am I suppose to put this code? As...

    Hi RG

    Where am I suppose to put this code? As for continuing on with a pop-up box, do you think I should start a new post?

    Jean
  2. Replies
    26
    Views
    839

    Hi RG Thank you very much for testing,...

    Hi RG

    Thank you very much for testing, cleaning and adding all that was needed for the wb up to this point. I learned a lot but I would not have been able to do it without your help. I am...
  3. Replies
    26
    Views
    839

    Exit code with a password

    Hi RG

    I have another problem with closing the wb without entering in the data in the exit code. The suggestion was to use the following code:

    If UsrName="HSO" Then Exit Sub

    Obviously that...
  4. Replies
    26
    Views
    839

    Hi RG That works great with the fringe. As...

    Hi RG

    That works great with the fringe. As for the Project Number, my change works. Maybe if you like I can send what I have and you can test it?

    Jean
  5. Replies
    26
    Views
    839

    Exit Code Continued ...

    Hi RG

    I am continuing with the exit code and going in order of the worksheets and the fields I want to capture on exit. I have the user form with project number working. This is what worked:
    ...
  6. Replies
    26
    Views
    839

    Exit Code Revised

    Hi RG

    I have started to clean up the exit code and I understand what I need to do to expand on the code titled--Private Sub Workbook_BeforeClose(Cancel As Boolean)--but how do I incorporate the...
  7. Replies
    26
    Views
    839

    Hi RG That works great--exactly what I needed...

    Hi RG

    That works great--exactly what I needed for my user group. As for cleaning up the exit code, I am agreeable if you want to tackle it, but I hope I am not taking you from more challenging...
  8. Replies
    26
    Views
    839

    Hi RG I finally had a chance to play with the...

    Hi RG

    I finally had a chance to play with the form in the cover sheet and I really like how it works. I enabled the exit code and did not have the same success with the input box. On the exit...
  9. Replies
    26
    Views
    839

    Create a Custom Number Format

    Hi RG

    The sheet "Cover" is where I want the user to type in the Project Number. I did add in your previous code into this sheet. "This Workbook" has the exit code which will drive you crazy--so...
  10. Replies
    26
    Views
    839

    Hi RG The code here is great but I do not know...

    Hi RG

    The code here is great but I do not know how to incorporate into what I already have. This user group makes so many mistakes with entering the Project Number that it drives me crazy with...
  11. Replies
    26
    Views
    839

    Hi RG This works great if my user group...

    Hi RG

    This works great if my user group fills-in the cell but I wanted it to also work on exit or close. I was looking for a way that the input box would retain the format and the user would not...
  12. Replies
    26
    Views
    839

    Create a custom number format

    Hi RG

    Is there any way I can use the code you provided into the following existing code: It was so easy formatting percent!! Jean


    Private Sub Workbook_BeforeClose(Cancel As Boolean)...
  13. Replies
    26
    Views
    839

    Create a custom number format

    Hi

    I have an input cell where the user needs to enter a project number. An example of a project number is 0194-0722-AB. It always starts with a zero, 4 digits, a hyphen, 4 digits, a hyphen, and...
  14. Replies
    4
    Views
    195

    Hi Maudibe This works great. Before I heard...

    Hi Maudibe

    This works great. Before I heard from you I did come up with code that worked when opening the WB, but it took to long to open the WB. This works so much better. Thank you.

    Jean
  15. Replies
    4
    Views
    195

    Excel WB that has required cell input!

    Hi

    I have an Excel WB that is set-up with several worksheets where I require input on various sheets before closing the WB. The WB is distributed to many users. I need the required cells to be...
  16. Replies
    9
    Views
    1,246

    Hi That works great. Thank you for the help....

    Hi

    That works great. Thank you for the help.

    Jean
  17. Replies
    9
    Views
    1,246

    Hi I did use a textbox with the drawing tool...

    Hi

    I did use a textbox with the drawing tool versus embedded forms textbox. The code worked great but I would like it to work on any worksheet tab in the workbook instead of the active sheet. To...
  18. Replies
    9
    Views
    1,246

    Excel code requiring input in textbox

    Hi

    I have a workbook with several sheets. The sheet named "Recap" has 6 textboxes where I want the user to enter text. If the user does not fill-in the textboxes I want the code to activate a...
  19. Iif statement in access query with color criteria

    Hi

    I am trying to alter the following IIF Statement:

    IIF(IsNull([Diff],"",IIF([Diff]>0, "Over","Not Over"))

    This is working correctly but I was wondering if there was a way to add in a light...
  20. Replies
    10
    Views
    1,892

    Hi Paul/Jeremy Thank you guys for all the...

    Hi Paul/Jeremy

    Thank you guys for all the help--it works perfectly and is a godsend not to have to adjust each workbook for importing.

    Jean
  21. Replies
    10
    Views
    1,892

    Hi Is there anyway you could just share with...

    Hi

    Is there anyway you could just share with me the exact code that would create the loop? I am not proficient in writing code--I just find code and adapt it!


    Jean
  22. Replies
    10
    Views
    1,892

    Hi Paul Sorry it took so long to get back to...

    Hi Paul

    Sorry it took so long to get back to you but it crashes on the If UCase ...
    Here is the code:


    Dim i As Integer
    Dim zXLFPath As String
    Dim zXLFName As String
    Dim...
  23. Replies
    10
    Views
    1,892

    Hi Paul It means changing 75 workbooks. So...

    Hi Paul

    It means changing 75 workbooks. So there is no easy fix to the existing code or any other code I can use and adjust?

    Jean
  24. Replies
    10
    Views
    1,892

    Hi Paul I need the code you suggested not that...

    Hi Paul

    I need the code you suggested not that savvy with understanding what you mean?

    Cheers, Jean
  25. Replies
    10
    Views
    1,892

    Need VBA code that changes field name in table

    Hi

    I found the following code to change a field name in a table:

    Dim dbs As DAO.Database
    Dim tdf As DAO.TableDef
    Dim fld As DAO.Field

    Set dbs = CurrentDb
    Set tdf =...
Results 1 to 25 of 58
Page 1 of 3 1 2 3