Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    2
    Views
    80

    Re: VB Maro for Excel

    .
    Preethi :

    How many different customers will you be emailing each time ? Your example shows three ... will there usually be more ? How many ?

    If there are usually more than say 12 different...
  2. Thread: data entry form

    by Logit
    Replies
    1
    Views
    51

    Re: data entry form

    .
    That is what happens when you hide a column or a row ... it disappears from view.

    You could create a macro that would make the columns/rows visible while you are working on the data, then hide...
  3. Re: How do I bring my excel program to the foreground?

    .
    You are welcome.
  4. Thread: Help with Macros

    by Logit
    Replies
    1
    Views
    109

    Re: Help with Macros

    .
    Here is a download link to a sample database project using a FORM.

    Compare the code to your project. If you have difficulty ... post again.
    ...
  5. Re: Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    ?????
  6. Re: Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    .
    It is very late here. Need to sleep.

    I'll check this in the morning to see how it turned out.
  7. Re: Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    .
    Ok .... in a Regular Module paste this macro :



    Option Explicit


    Sub ProjNumbrReq()
  8. Re: Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    .
    You can only use Before Save once in ThisWorkbook module :





    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
  9. Re: Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    The error didn't display correctly.

    ???
  10. Re: How do I bring my excel program to the foreground?

    https://www.extendoffice.com/documents/excel/2030-keep-excel-window-on-top.html
  11. Re: Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    .
    The macro should be pasted into a Regular Module not in the ThisWorkbook module.

    To have the macro run when the user saves the workbook paste this macro into the ThisWorkbook module :


    ...
  12. Re: Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    .


    Please be more specific. How is the User accessing the 'save or save as' buttons ?
  13. Re: Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    .
    Try this :





    Sub ProjNumbrReq()

    Static alreadyPrompted As Boolean
  14. Re: Making a pop-up form work from a merged cell

    .
    Your code seems to work if you merge only TWO CELLS (H2 & I2). Would that still allow your sheet to
    display how you wanted ?
  15. Re: Duplicate data in consecutive rows highlighted

    .
    This is a different version :



    Option Explicit


    Sub HighlightDups()
    Dim c As Range
  16. Re: Duplicate data in consecutive rows highlighted

    Option Explicit


    Sub DeleteDups()

    Dim x As Long
    Dim LastRow As Long
    Dim Cells As Range
    Application.ScreenUpdating = False
  17. Re: Need a macro to completely stop running, then start again on its own.

    .
    My apologies .... there is one line of code omitted from the macro. This is the corrected macro :



    Option Explicit '<-- this statement at the top of everything makes you declare all your...
  18. Replies
    2
    Views
    98

    Re: Maximising Profit

    You have the hourly cost of electricity for a past year. How does that apply to a forthcoming year ?

    If I know the price of gas on November 15, 2018 doesn't mean the cost will be the same this...
  19. Re: Duplicate data in consecutive rows highlighted

    .
    This is one method. Will delete the duplicate row.



    Option Explicit


    Sub DeleteDups()
  20. Re: Need a macro to completely stop running, then start again on its own.

    Post #4 .
  21. Replies
    7
    Views
    150

    Re: VB colors name list

    The list of VB colors you provided is all there is ... for VB colors.

    Check out this resource for other methods :

    http://dmcritchie.mvps.org/excel/colors.htm
  22. Replies
    1
    Views
    81

    Re: Sending Emails to Muliple People

    .
    This slightly edited macro functions if pasted into the Sheet 1 module and a change of data is made in cell I4.

    What additional changes were you wanting to make ?



    Option Explicit
  23. Thread: overwhelmed

    by Logit
    Replies
    6
    Views
    632

    Re: overwhelmed

    Thank you for responding.

    Perhaps it is just another of those little querks my copy of Excel 2007 wants to express.
    It has a number of them.

    Cheers !
  24. Replies
    10
    Views
    260

    Re: VBA to launch userform by selecting a cell

    .
    Download : https://www.amazon.com/clouddrive/share/8VRyKjsZmuDcqyPt6rcppLkjDt5tzwaTDt6wZKb0HSD
  25. Replies
    10
    Views
    260

    Re: VBA to launch userform by selecting a cell

    "launch userform by selecting a cell" and maintain the original design allowing for selecting from the entire list instead of the cell selection that was clicked.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4