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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 =...
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.
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...
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...
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...
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...
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())
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
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...
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...