Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Thanks Brian. Actually Adding another level...

    Thanks Brian. Actually Adding another level would be a matter of just duplicating the code with a few changes. The problem lies in that to get another level in, many changes to the horizontal...
  2. Thanks Paul. Still needs some tweaking to update...

    Thanks Paul. Still needs some tweaking to update textboxes when changes are made
  3. Replies
    18
    Views
    836

    Thanks bhushan. RG, Your code reinforces...

    Thanks bhushan.

    RG,

    Your code reinforces the same technique I used in post #15 of offsetting from a reference point established by the Application.Caller. Thanks.



    Public StatusVal As...
  4. Paulo, If you want to manipulate the data,...

    Paulo,

    If you want to manipulate the data, maybe something like this might help.

    Your data is entered via a form that pops up when you click on the "New Item" button. There are combo boxes...
  5. Replies
    18
    Views
    836

    bhushanvshah, Real easy adjustment! Besides...

    bhushanvshah,

    Real easy adjustment! Besides adding the new column on the sheet1, there only needs to a change to 1 line of code:

    From:


    If perimeter > 10 Then
  6. You're Welcome Dave. PM me if I can help...

    You're Welcome Dave. PM me if I can help further.

    Maud
  7. Replies
    18
    Views
    836

    bhushanvshah, If Martin's clever work does not...

    bhushanvshah,

    If Martin's clever work does not meet your needs, consider the following workbook using your file in post #8.

    The values changed on the Input sheet (sheet2) equates to values...
  8. Alan, Interesting thread. I had noticed...

    Alan,

    Interesting thread. I had noticed issues similar to yours in the past which gave me them impression that perhaps multi-threading cores might be the issue. Code should have executed in a...
  9. Replies
    18
    Views
    836

    Bhushanvshah, I got all that on your opening...

    Bhushanvshah,

    I got all that on your opening post. The point I was making is that a recalculation can initiate data sent to a log. Whether new values come from sheet 2, another workbook, or the...
  10. Dave, Here are the changes you need to have...

    Dave,

    Here are the changes you need to have made:



    Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    'PRESSING ENTER WILL BE SAME AS CLICKING OK BUTTON
    OKButton_Click
    End...
  11. Replies
    18
    Views
    836

    bhushanvshah, This was set up as an example to...

    bhushanvshah,

    This was set up as an example to use the workbook and worksheets that I provided.

    Re-download the workbook. Don't change the name of any of the worksheets. I can alter the...
  12. Replies
    15
    Views
    322

    Verada, Consider a flexible UDF that will...

    Verada,

    Consider a flexible UDF that will allow you to add an optional condition as you requested in Zeddy's formula. The syntax is:

    =CompDate(CloseDate As Range, DueDateOffset As Long,...
  13. I am sure there is a quick way, maybe with paste...

    I am sure there is a quick way, maybe with paste special, but here is a very versatile solution. Enter the following formula in s standard module then assign the macro s a shortcut key such as...
  14. X_LD, Make sure you downloaded Tree_2,xlsm. ...

    X_LD,

    Make sure you downloaded Tree_2,xlsm. Select the book, a chapter, a section, or subsection on the data sheet and then click the build tree button. The tree will be built on the Tree...
  15. [SOLVED] Moshin, Here is some code that will import...

    Moshin,

    Here is some code that will import your text file and reformat it to accommodate your Orders Details. You can rename the sheet if you like. In cell B1, enter the full path of the text...
  16. Replies
    18
    Views
    836

    Brushan, Consider the following workbook that...

    Brushan,

    Consider the following workbook that calculates the perimeter and area of a circle based on radius values on sheet 2. On sheet 1, columns F and G have the formulas. If you change the...
  17. Replies
    15
    Views
    322

    Being that the posted file is .xls, are you...

    Being that the posted file is .xls, are you running Excel 2003? I might be wrong but Countifs does not work in 2003.
  18. Dave, Here is the file that when the Service...

    Dave,

    Here is the file that when the Service Rep double clicks the desktop icon for the file, an input box will open prompting the input of the computer name. If the Rep clicks cancel or the red...
  19. Don, Enter the following code into the...

    Don,

    Enter the following code into the ThisWorkbook module. Access the module using the instructions I provided in my first post. Check for a similar line of code equaled to True elsewhere in...
  20. Absolutely! Will work on it shortly. 1. Will...

    Absolutely! Will work on it shortly.

    1. Will the users use the app like you did to pull up the computer name? If desired, we can make that appear in a message box so the user can reference it...
  21. Don, You will find it on the Developer Tab ...

    Don,

    You will find it on the Developer Tab

    40657

    HTH,
    Maud
  22. Replies
    4
    Views
    203

    Phantom, I added some code to insert the date...

    Phantom,

    I added some code to insert the date and time the reminder was created to alert the user.

    40653

    HTH,
    Maud
  23. Replies
    4
    Views
    203

    Phantom, Consider this code where the user...

    Phantom,

    Consider this code where the user selects any cell in the row of a forklift then clicks your "Create Reminder" button. The code will check to see it Outlook is running then creates a...
  24. Don, Open the VB editor by pressing Alt-F11...

    Don,

    Open the VB editor by pressing Alt-F11 and double click ThisWorkbook in the VBA project pane. If there is code there, look for the line indicated in blue and place an apostrophe in front of...
  25. Does the lender have a service charge added to...

    Does the lender have a service charge added to the bill? Are you rounding your calculations which can alter the results slightly?
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4