• 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

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. dparteka

    Third Level Formula Does Not Update

    See the attached worksheets. WS-01… A1 has an entry of $100 WS-02… A1 has formula ='[WS-01.xlsx]Sheet1'!$A$1 WS-03… A1 has formula ='[WS-02.xlsx]Sheet1'!$A$1 All worksheets are setup to “Don't display the alert and update links” When I change to $200 in WS-01, WS-02 also changes to $200 but...
  10. dparteka

    Print Worksheet and Hyperlinks

    I may be asking for a bit of a magic trick here. I have a worksheet that has hyperlinks to other workbooks. I’m looking to create an ActiveX command button to print the active worksheet and all the hyperlinks in column-D. The linked workbooks and the number of hyperlinks is not static, so the...
  11. dparteka

    Validation List... N/A otherwise look to the lists

    Not sure if this is possible but it’ll be interesting to see if it is. In cell P1 I have this List Validation formula that does the job nicely. =INDEX(INDIRECT(O1),0,1) Here's the List Validation in O1...
  12. dparteka

    SendKeys "{F2}" and "{ENTER}"

    I have a group of cells N6:N37 that need to be refreshed in order for the formulas to produce a return. This can be done manually by the key strokes F2 followed by the Enter key. I have been trying to create a macro like the one shown below but it does not work and might be a known Microsoft...
  13. dparteka

    Check if external link exists before updating

    I have a main-workbook that has hundreds of links to sub-workbooks. The sub-workbooks get created daily so their quantity is always growing day by day. The main-workbook already has all the links to the existing sub-workbooks in it and also the ones that have yet to be created. I'm using the...
  14. dparteka

    INDEX and MATCH

    I’m using an INDEX MATCH combination formula; VLOOKUP doesn’t work because what I’m trying to return is to the left of the lookup. The formula I’m using works good except I’m looking to also have it continue down the list, skip over the one it just found and then find the next one and continue...
  15. dparteka

    Data Validation... Only Numbers, Hyphens and N/A

    I'm using the formula below in a data validation and it works fine. It allows only numeric value entries with the one exception of an upper case "N/A". I've been trying to expand on this to also include the use of hyphens. So, legitimate entries would be an uppercase N/A or any number...
  16. dparteka

    Unlock a range based on cell value

    I could use help with this, I've gotten the CommandButton portion to work but I'm stuck on the unlocking the range part, if someone out there could enlighten me I’d really appreciate it... thank you for looking Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Unlock L5:L6 when N5 =...
  17. dparteka

    Data Validation to Prevent Duplicate Entry from List

    I have two cells that have the same entry possibilities from a validation list. I’m looking to avoid having the same entry in those two cells. Additional explanation is included in the attached workbook. Thank you for looking and the help is really appreciated.
  18. dparteka

    Mask Entries

    The code below works fine, I'm looking to mask the password entry. I've researched the internet and found some postings that claim masking is not possible with an InputBox, does anyone know if this claim is true? Dim Pass As String Dim Prompt As String Dim Title As String Dim...
  19. dparteka

    Unlock Cell Based on a Character in Another Cell

    I have this code that works great but I'm looking to tweak it a bit by changing SubRng.EntireRow.Locked = False which unlocks the entire row to having it unlock only the single cell in that row in column F... thanks for looking and I appreciate the help. Dim Rng As Range Dim SubRng As Range Set...
  20. dparteka

    Using =INDIRECT() in a Data Validation with Multiple Column Tables

    I’m using the formula shown below in a list data validation in cell K2. There are three possible entries in J2, they are Employee, Customer or Supplier, each of these are individual tables that have two columns each. As it is now when I select the drop down in K2 it displays the table data in a...
  21. dparteka

    Remove CF's, DV's, Formulas & Protect

    I've been attempting to put this together and have concluded it's just beyond my skill level, any help would be awesome and greatly appreciated... thanks for looking. I'm using the code shown below which looks in column-A for "+", then for all rows that have this character it locks each cell in...
  22. dparteka

    Static =TODAY() Function

    Does anyone know if there is a way to use =TODAY() in a formula and once the date appears it never changes, I'm looking at something like this... thanks for looking. =IF(A1="","",TODAY())
  23. dparteka

    Data Validation to Prevent Blank Cells in a Row

    I'm on a roll here with Data Validation, hopefully with the help I'm getting it'll eventually sink in. I'm looking for a data validation that will prevent blank cells… a more specific explanation is included in the attached spreadsheet... thank you for looking
  24. dparteka

    Data Validation Upper Case & "N/A" Exception in Number Field

    I'm attempting to create a custom data validation that forces only upper-case and makes the text "N/A" exception in a field that is formatted to output only numbers. I have code for the upper-case portion and the "N/A" portion but am unable to bring them together in a single validation formula...
  25. dparteka

    Guidelines for Donations

    I'm hoping this is the correct forum for this and if not then I apologize. I've searched the site for some kind of guidelines for giving donations but have not found much, except that it would make me awesome to do so... I am open to becoming awesome, but I do have just two questions. How is...
Back
Top