• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. dparteka

    Update links and exit the Sub at the first link that is not found

    Excellent Monty... thank you
  2. dparteka

    Update links and exit the Sub at the first link that is not found

    I have a main spreadsheet that houses many links to many other spreadsheets. Some of the other spreadsheets have not yet been created so they literally do not exist. I'm using the code shown below to update those links in the main-spreadsheet and that works perfectly fine but when it gets to the...
  3. dparteka

    Update a formula reference based on another cell

    That I did not know. So, when you have both workbooks opened the formula works for you? I still get the #REF!, I guess I'll have to come up with a plan-B on this... thanks for the Hui
  4. dparteka

    Update a formula reference based on another cell

    Attached are the two workbooks... 1422A-000 QCR has the formula you provided that is returning a #REF! in cell A5
  5. dparteka

    Update a formula reference based on another cell

    Thanks Hui... I do completely understand your formula and it seems like it should work but it's not working for me, it's returning a #REF!. I tried a few tweaks but no change, what am I missing, do you have any ideas why it's not working for me?
  6. dparteka

    Update a formula reference based on another cell

    I’ve attached two workbooks, we’ll call the 101A-000 the data file, the 1422A-000 has a reference to that data file. I simply want to create a formula in 1422A-000 that will update based on another cell, you’ll find more explanation on that in the spreadsheet. Thank you for looking and I greatly...
  7. dparteka

    Delete Conditional Format in D:D if "OPEN" Appears in C:C

    p45cal... you make that look easy, works great, thank you very much
  8. dparteka

    Delete Conditional Format in D:D if "OPEN" Appears in C:C

    The code below deletes conditional formatting in the entire row if "OPEN" appears in column-C, I'm trying to figure out how to get it to delete only in Column-D. For example, if C5 and C8 are the only ones that have “OPEN” in them then CF would be deleted in only D5 and D8. Any help will be very...
  9. dparteka

    Look in the Entire Column

    That's a thing of beauty, work's perfectly, thank you very much
  10. dparteka

    Look in the Entire Column

    This code checks cell B5 for a hyphen and if it’s there then it displays Commandbutton2, works good. I'm looking to modify it slightly so it looks in the entire column or a range like B5:B24 for example... thanks for looking, any help will be very appreciative. Private Sub...
  11. dparteka

    ISFORMULA not working with Conditional Format

    VBA code converts the cell from formula to value. This is done to lock in the date... keeping the formula in tack will result in it continually updating to NOW(). Something I just discovered, if I open GraH-Guido's workbook the conditional formatting as he has it does work on my home Office 365...
  12. dparteka

    ISFORMULA not working with Conditional Format

    David… what you describe is exactly what I’m shooting for. With the formula in column-D, when I select OPEN I get black font… should be red like you are seeing but it’s not. GraH… altering the condition as you have it changed nothing for me, still no red. If I use the opposing formulas I get...
  13. dparteka

    ISFORMULA not working with Conditional Format

    I feel like a deer staring at headlights, I think I need a different set of eyes to look at this, what am I not seeing here? I'm using =ISFORMULA(D5) in a conditional format which should result in the font in the entire row to go red as long as D5 has a formula and then go Auto(black) once that...
  14. dparteka

    VBA to Send Text Message to Cell Phones

    OMG Kenneth, that was painless. You made something that I thought would be nearly impossible to do look incredibly easy even though to me it looks outrageously complicated. You should get an award, I can't thank you enough, this is the coolest VBA thing I have ever seen, Excel talking to my cell...
  15. dparteka

    VBA to Send Text Message to Cell Phones

    The idea is to click on an Excel ActiveX button that houses VBA code that sends a text message that reads “You have a new request” to cell phone numbers 2623700361@vtext.com and 2623703023@vtext.com followed by an Excel MessageBox that displays “Your Request Successfully Sent” Thank you for...
  16. dparteka

    Idle Time Message Box with Counter

    Hello again Deepak... your code is still working perfectly and although that is great news it hasn't had the overall effect I was hoping for. The goal was to stop the loitering and for most using the spreadsheet this has worked but there are some that walk away from their desk for long periods...
  17. dparteka

    Message Box Always on Top

    Okay guys, thanks for the confirmations, I'll explore other avenues, thank you for all your help
  18. dparteka

    Message Box Always on Top

    Hope this helps, thanks again for looking Below is in ThisWorkbook module Option Explicit Private Sub Workbook_BeforeClose(Cancel As Boolean) StopTimer End Sub Private Sub Workbook_Open() StartTimer End Sub Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)...
  19. dparteka

    Message Box Always on Top

    Logit... thank you for your input, just like the other examples I listed above including the "+ vbSystemModal" only causes the app button in the task bar to flash, it does not bring the message box on top of all other opened windows. vletm... no new case, yes I'm still trying to get my message...
  20. dparteka

    Idle Time Message Box with Counter

    Deepak... awesome, works perfectly, thanks again
  21. dparteka

    Message Box Always on Top

    Vletm... thanks but all that does is cause the app button in the task bar to flash just like these others AppActivate Application.Caption Application.Workbooks(ThisWorkbook.Name).Activate ThisWorkbook.Activate Application.WindowState = xlNormal AppActivate "Microsoft Excel"
  22. dparteka

    Message Box Always on Top

    Below is a line of code, when executed the message box does not appear on top of other windows that are open. Does anyone know if it's possible for this message box to always pop-up on top of all other opened windows? Thank you for looking, any help will be greatly appreciated. MsgBox "My...
  23. dparteka

    Idle Time Message Box with Counter

    Deepak... although your code is not influenced by idle time it can still serve the purpose, I just need to take a different approach, thanks again, I'm very appreciative.
  24. dparteka

    Idle Time Message Box with Counter

    I’m looking for some ninja level help here… I have found bits and pieces of this on several sites but I have not been able to put it together. I have people loitering in a spreadsheet, basically they open it and keep it open for no good reason which prevents others from accessing it, so I’m...
  25. dparteka

    Third Level Formula Does Not Update

    Luke M... the problem is I have another workbook that is looking for the updated value in WS-03 which would not be opened… but as Haz has confirmed WS-03 will not auto update/recalculate on its own... so I'm off to plan "B" for a solution. Thanks guys for your comments, they have helped me to...
Back
Top